Using VLOOKUP in an array

Giganews Newsgroups
Subject: Using VLOOKUP in an array
Posted by:  Robert A (…
Date: Tue, 18 May 2004


When I use VLOOKUP in an array as follows, 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 Ades Accountancy Corp.
12100 Wilshire Blvd., Suite 660
Los Angeles, CA 90025
Tel:  310-571-1224
Fax:  310-571-1227