vlookup

  • Thread starter Thread starter Leisa W
  • Start date Start date
L

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
 
Leisa W said:
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
Click to expand...

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,C1:D50,2,0)
 
Back
Top