View Single Post
 
Old 12-12-2014, 06:46 AM
itmaster itmaster is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Dec 2014
Posts: 4
itmaster is on a distinguished road
Question 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:
A B C
Test car False
job Test A1
Bob House False
Kite Job A2
Thank you

Last edited by itmaster; 12-12-2014 at 06:52 AM. Reason: Table culmped together
Reply With Quote