Finding a value in one column and in another

		Microsoft Office Forums > Microsoft Excel > Excel
Finding a value in one column and in another

FAQ

Thread Tools

Display Modes

12-12-2014, 06:46 AM

itmaster

Windows 7 64bit Finding a value in one column and in another

Office 2010 64bit

Novice

Join Date: Dec 2014

Posts: 4

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

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