find matches in two columns of unique IDs and return result

**fattony75** · 10-26-2009, 03:51 PM

Hi,

I am a newbie to Excel (version 2007).

I have two columns of unique IDs. One located in Column A and one located in Column B. How do I find if there are unique IDs in Column A that are in Column B and then return them in Column C? Would using the functions VLOOKUP and MATCH solve the problem?

Thanks in advance

.
FT

**teylyn** · 10-26-2009, 04:24 PM

Hi,

something like this maybe?

=IF(ISNA(VLOOKUP(A2,B$2:$B$10,1,FALSE)),"",VLOOKUP(A2,$B$2:$B$10,1,FALSE))

see attached

**zbor** · 10-26-2009, 04:28 PM

something like this:

Book1.xls

**fattony75** · 10-27-2009, 02:59 PM

many thanks for your reply...

..i think we are nearly there...

the excel function has to compare all the unique values in column A to those unique values in column B and return a match in column C. Does that make more sense?