| Home |
| Search |
| Today's Posts |
|
|
|
#1
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) | |||
Hybrid Mode
