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???

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???

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???