2 column lookup or match

[Gromit]

Hi folks,

I have two sheets, each with LastName and FirstName columns. The secon
sheet has a State column.

What I want to do is create some kind of lookup formula in the firs
sheet that returns the State when both the LastName and FirstName matc
on both sheets.

I guess the answer looks something like:

=OFFSET(AND(MATCH(A1, Sheet2!A1), MATCH(B1, Sheet2!B1)), 0, 3)

But I can't quite find the right combination.

Any ideas?

Thanks,

Graha

 

[jeff]

Hi,

Try this
=IF(AND(MATCH(A10, Sheet2!A10), MATCH(B10, Sheet2!
B10)),OFFSET(Sheet2!A10, 0, 2),"")

hth
jeff

 

[Gromit]

Thanks Jeff