Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Kind of Vlookup
Can someone help me with this one?
I want to write a function similiar to Vlookup; Except it should be able to take more than one lookup value and the add the values returned; For Example Column A Column B Acc100 R 1000 Acc200 R 2000 Acc300 R 3000 Acc400 R 4000 The function should search Range(A1:B4) for say Acc100 and Acc300 an then add the corresponding values from Column B R1000 + R 3000 ; Thanks -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Kind of Vlookup
Hi
one way: =SUMIF(A1:A100,"Acc100",B1:B100)+SUMIF(A1:A100,"Ac c300",B1:B100) or try =SUMPRODUCT(--(A1:A100={"Acc100","Acc300"}),B1:B100) -- Regards Frank Kabel Frankfurt, Germany Can someone help me with this one? I want to write a function similiar to Vlookup; Except it should be able to take more than one lookup value and then add the values returned; For Example Column A Column B Acc100 R 1000 Acc200 R 2000 Acc300 R 3000 Acc400 R 4000 The function should search Range(A1:B4) for say Acc100 and Acc300 and then add the corresponding values from Column B R1000 + R 3000 ; Thanks! --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A different kind of VLookup | Excel Discussion (Misc queries) | |||
Looking for a function that performs a special kind of Vlookup | Excel Discussion (Misc queries) | |||
More vlookup questions (I think?)(kind of long) | Excel Discussion (Misc queries) | |||
Kind of a reverse vlookup | Excel Worksheet Functions | |||
Some kind of vlookup required? | Excel Discussion (Misc queries) |