Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking for a function to search and coincide
Hi Dario,
assuming that the cell when you will imput John2 is D2. on e2 use this function: =vlookup(d2,a2:b100,2,0) assuming that the data is on the a2:b100 range, adjust it as your convinience hth regards from Brazil Marcelo "Dario" escreveu: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|