vLookup with multiple lookup value in table array
 

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!

vLookup with multiple lookup value in table array
 

I would start by looking he
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
--
Brevity is the soul of wit.


" wrote:

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!

vLookup with multiple lookup value in table array
 

Hello,

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

HTH,
Bernd