Excel 2007: One column is text, next column is value.?
-
I want to link these 2 columns to be true, so that in other worksheets when the SAME TEXT is entered, the associated value comes up in the next column automatically. Is this possible? I need a specific formula because apparently I am having issues. The text column is B and the value column is C. THANK YOU!
-
Answer:
EXACT compares to columns, so for your answer column (C): =IF(EXACT('sheeta'!B1,B1), 'worksheet'!C1, 0) So if you enter text in B1 on a worksheet, it compares this text to that of B1 on 'sheeta' (or whatever you want to call it). If TRUE (equal), the value that shows up im C1 is copied from C1 on 'sheeta', otherwise it's zero (or whatever you want.
JM at Yahoo! Answers Visit the source
Other answers
use vlookup() function. check link below. hope it helps because your question is not clear to me :)
Related Q & A:
- How can I plot more than one value in the same date?Best solution by Mathematica
- How to get the column value when a row is selected in wpf listview?Best solution by Stack Overflow
- How to get Count of each Column value of table?Best solution by Stack Overflow
- How to find the column name of the first column with a null value?Best solution by Stack Overflow
- How to make Outlook 2007 as default for emails while sending files directly from Word or Excel as attachments?Best solution by Super User
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.