vlookup

[Leisa W]

Hi,

I am trying to use a vlookup to retrieve data regarding my
customers. I have customer surnames which appear more than
once. When I vlookup it only returns the first "smith"!!
Can I get Vlookup to look at say a last name AND a first
name upon which to make it's decision and return the
relevant data? I have a column for surname and first name.

stuck

Leisa

 

[Paul]

Hi,

I am trying to use a vlookup to retrieve data regarding my
customers. I have customer surnames which appear more than
once. When I vlookup it only returns the first "smith"!!
Can I get Vlookup to look at say a last name AND a first
name upon which to make it's decision and return the
relevant data? I have a column for surname and first name.

stuck

Leisa

You could add a column (say C) in your customer list that is just a
concatenation of last name and first name:
=A1&B1
Then you could look up a customer (whose names were in, say A99 and B99) in
this column:
=VLOOKUP(A99&B99,C150,2,0)