View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dario Dario is offline
external usenet poster
 
Posts: 1
Default Looking for a function to search and coincide

I'm looking for a function to do this.
I have names values in the "A" raw, and for each A correspond a Value in "B"
raw.

So, in another cell I input a value of the "A" raw and i need that it search
the value coincident with "A" and "B"-

For ex.

"A" | "B"
JOHN2 | 25
CECE3 | 30


HERE I NEED

input ---- JOHN2 ----- it gives me ----- 25

is ts possible? how?