#1
|
|||
|
|||
Finding a value in one column and in another
Hi,
I have two columns, on the same sheet, and I wnat to look at the values in one column and see if a given value is in another; and then in a third column show that it is in the first column, and the cell that it is in. If this is not possible, it can just show True or False. For example; Quote:
Last edited by itmaster; 12-12-2014 at 06:52 AM. Reason: Table culmped together |
#2
|
||||
|
||||
Hi
do you really need the cell reference if true? What would you do with it?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Well it would be nice, if I had a lage table and other collumns like dates that I wanted to compare, but that is okay how would you do this with True. I tryed formulas and Vlookups and I am doing something wrong I canot get it. Do you have any idea of what I can do?
Thank you |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Want a quotient using a constant to show up in column c each time a number is added to column b | fibbermcghee | Excel | 2 | 12-09-2014 05:48 PM |
Parsing 'FullName' column - help needed text to column | ScottA | Excel Programming | 3 | 05-06-2014 12:49 PM |
Automatically enter date into a column and make that column read only | Mr Davo | Excel | 1 | 10-29-2012 01:07 AM |
Can I change the horizontal scrollbar to scroll smoothly rather than column by column | carpat | Excel | 0 | 01-10-2012 09:34 AM |
Need to search a column for a macth and return a result from a third column | pdfaust | Excel | 2 | 02-03-2011 03:02 PM |