Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i get multiple values in vlookup?
hello.
i am a project planner and doing a quantity analysis whose spreadsheet is huge & simalar to this eg : code quantity a 12 s 3 d 45 total A = 12 a 6 g 67 a 7 d 88 when i tried the vlook up finction =VLOOKUP(A2,A1:B8,2,FALSE) it gives me the value 12 instead of the summation (12+6+7= 25) is dere any way i can get multiple values using vlokup. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple VLOOKUP | Excel Worksheet Functions | |||
VLOOKUP - Multiple cells in lookup value | Excel Worksheet Functions | |||
Multiple if or multiple vlookup | Excel Worksheet Functions | |||
VLookup for multiple values!! | Excel Worksheet Functions | |||
VLOOKUP to search multiple values? | Excel Worksheet Functions |