Hi,

Considering you have first name and surname in 2 different columns, you can
try this

=lookup(2,1/((range1="firstname")*(range1="surname")),lookup_r ange)

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"purplerose" wrote in message
...
I am trying to use Vlookup to return a value. I can get it to search for a
surname and then return the appropriate value but I have duplicate
surnames
(jones etc!) that should return different values.

Currently my formula just returns the first value it finds. Can I lookup 2
columns (first name and surname?)

Would appreciate any help,

Thanks