| 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