View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vanessa Simmobds
 
Posts: n/a
Default how do i use the vlookup with two references ?

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????????