how do i use the vlookup with two references ?

G

Guest

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

Chip Pearson

Try the following formula. Adjust the ranges as required.

=SUMPRODUCT(--(A1:A10="marcelo"),--(B1:B10="silva"),C1:C10)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Vanessa Simmobds" <Vanessa (e-mail address removed)>
wrote in message
news:[email protected]...
 
G

Guest

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
 

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

Reference - Vlookup 1
Referencing 2
how do I use array references in VLOOKUP()? 2
Vlookup using dates in the lookup range 5
how do i get multiple values in vlookup? 5
How to use VLookup with a range of numbers? 3
How do i use vlookup to find more than 1 entry 3
Excel Coding Error! 9

Top