Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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???????? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i use the vlookup with two references ?
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 wrote in message ... 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???????? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i use the vlookup with two references ?
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 "Vanessa Simmobds" wrote: 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???????? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating cell references with variable values to use in Vlookup | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Using Cell references in VLookUp | Excel Worksheet Functions |