Using VLOOKUP in an array

Giganews Newsgroups
Subject: Using VLOOKUP in an array
Posted by:  Robert A (robert.ad…@verizon.net)
Date: Tue, 18 May 2004

Group:

When I use VLOOKUP in an array as follows, the formula returns only the
result of C5 times (D5 through D10):

=SUM(VLOOKUP(B36,Returns,C5:C10))*(D5: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

___________________________
Robert Ades Accountancy Corp.
12100 Wilshire Blvd., Suite 660
Los Angeles, CA 90025
Tel:  310-571-1224
Fax:  310-571-1227

robeā€¦@robertades.com

Replies