Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vLookup with multiple lookup value in table array
Hi,
I'm trying to use a vLookup and running into trouble. On the table array that I'm looking in there are multiple instances of the lookup value. Does anyone have any recomendations for a quick/easy way to got the totals of the multiple lookup values? Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vLookup with multiple lookup value in table array
I would start by looking he
http://www.ozgrid.com/Excel/excel-vlookup-formula.htm Are you using the FALSE argument in your VLOOKUP? I believe that if you're looking for an exact match (which the FALSE argument returns) VLOOKUP will work only if there is ONE exact match. Else, Excel doesn't know what to do with multiple exact matches. Dave -- Brevity is the soul of wit. " wrote: Hi, I'm trying to use a vLookup and running into trouble. On the table array that I'm looking in there are multiple instances of the lookup value. Does anyone have any recomendations for a quick/easy way to got the totals of the multiple lookup values? Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vLookup with multiple lookup value in table array
Hello,
If your search values are in A1:A99 and the lookup values in B1:B99: =sumproduct(--(searchvalue=A1:A99),b1:b99) HTH, Bernd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions | |||
VLOOKUP keeping array lookup reference | Excel Discussion (Misc queries) | |||
IF, VLOOKUP & LOOKUP TABLE ON OTHER SHEET | Excel Discussion (Misc queries) | |||
Table array in VLOOKUP (EXcel 2003) | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) |