Need a formula to lookup the value of two cells

[EBerger]

Hello,

Pretty simple I'm sure.

I have two columns, one that contains FIRSTNAME the other contains LASTNAME. There are almost 2,000 people on the list.

I was given another list of only 400 people. Some may be on the original list some are not.

I want to add a column on the list of 400 people that will read TRUE or FALSE based on if their first and last name match the original list.

I am aware that some people may have the same name and not worried about that right now.

I would prefer a formula to VBA.

You guys are the best!

 

[onlyadrafter]

Hello,

WHy not add a column to add the two names together

=A1+B1

do this on both sheets then use MATCH

i.e.

=IF(ISERROR(MATCH(C1,Sheet2!C:C,0)),FALSE,TRUE)