vLookup with multiple lookup value in table array

[johnson.neil]

Hi,
I'm trying to use a vLookup and running into trouble. On the table
array that I'm looking in there are multiple instances of the lookup
value. Does anyone have any recomendations for a quick/easy way to got
the totals of the multiple lookup values?
Thanks!

 

[Guest]

I would start by looking here:
http://www.ozgrid.com/Excel/excel-vlookup-formula.htm

Are you using the FALSE argument in your VLOOKUP? I believe that if you're
looking for an exact match (which the FALSE argument returns) VLOOKUP will
work only if there is ONE exact match. Else, Excel doesn't know what to do
with multiple exact matches.

Dave

 

[bplumhoff]

Hello,

If your search values are in A1:A99 and the lookup values in B1:B99:
=sumproduct(--(searchvalue=A1:A99),b1:b99)

HTH,
Bernd