how do i use the vlookup with two references ?

V

Vanessa Simmobds

Hello,

I would like to use the vlookup functions with two references.
Example:

Name Surname Age
Marcelo Tavechio 25
David Steven 28
Marcelo Figueiredo 34
Vanessa Simmonds 25
Marcelo Silva 45

I want it to look up for Marcelo than for Silva than show the value of 45.

Is it possible????????
 
C

CLR

Insert a helper column just to the left of your data and CONCATENATE the two
name collumns into it, like Marcelo_Silva, and then use your VLOOKUP formula
on the concatenated values....=VLOOKUP(Marcelo_Silva,YourRange,4,false)


Vaya con Dios,
Chuck, CABGx3
 
Top