Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP - calculating multiple hits
Hi,
I need to calculate multiple Vlookup data hits. In my spreadsheet, I need to search for 'UK' in one column, and return the corresponding values of another column, but calculate the total of these values if there is more than one 'UK' hit. Any ideas??? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP - calculating multiple hits
Hi Carol
Please tryt he below =IF(COUNTIF(E2:E10,"UK")1,SUMIF(E2:E10,"UK",F2:F1 0),VLOOKUP("UK",E2:F10,2,FALSE)) I assume that UK is listed in col E and corresponding data is in col F HTH, -- Pranav Vaidya VBA Developer PN, MH-India If you think my answer is useful, please rate this post as an ANSWER!! "carol" wrote: Hi, I need to calculate multiple Vlookup data hits. In my spreadsheet, I need to search for 'UK' in one column, and return the corresponding values of another column, but calculate the total of these values if there is more than one 'UK' hit. Any ideas??? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP - calculating multiple hits
One way:
=SUMIF(A:A,"UK",B:B) In article , carol wrote: Hi, I need to calculate multiple Vlookup data hits. In my spreadsheet, I need to search for 'UK' in one column, and return the corresponding values of another column, but calculate the total of these values if there is more than one 'UK' hit. Any ideas??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I add multiple values in an array based on multiple hits? | Excel Discussion (Misc queries) | |||
When countdown hits zero | Excel Discussion (Misc queries) | |||
MS Excel 2003 CTRL+F missing hits | Excel Discussion (Misc queries) | |||
multiple hits in random sequences | Excel Worksheet Functions | |||
lookup help with multiple hits | Excel Worksheet Functions |