Looking for a function to search and coincide

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

need help on either doing a loop and counting specific values orusing subtotal function 2
sumif / sumproduct for number of coincidences 2
If and Vlookup 3
Excel Concatenate Form Name to Parse for function 1
Traspose Column data into Row 3
How to weave in Date Information please? 4
How do I weave in "date" information to my formulas? 2
resettable, over-ridable, default cell values 0

Back
Top