Using VLOOKUP in an array

[Robert Ades]

When I use VLOOKUP in an array as follows:

=SUM(VLOOKUP(B36,Returns,C5:C10))*(D510)

....the formula returns only the
result of C5 times (D5 through D10)

I'm trying to get C5 times D5, C6 times D6, etc.

I've been struggling with this for a week. How can
VLOOKUP be used properly
in an array?

Robert

 

[Guest]

Try usin

=SUMPRODUCT(C5:C10,D510)

 

[Frank Kabel]

Hi
see your other post
P.S.: please don't multipost

 

[Robert A]

Thanks, but I also need to use a LOOKUP function to pull data from a table.

Robert Ades