Help with an array

Giganews Newsgroups
Subject: Help with an array
Posted by:  Robert A (robert.ad…@verizon.net)
Date: Fri, 14 May 2004

=3D{SUM(VLOOKUP($B36,Returns,COLUMN(INDIRECT($B$5:$B$25)))*D$5:D$25)}

This formula won't work as an array, but it will work like this:

=3D(VLOOKUP($B36,Returns,COLUMN(INDIRECT($B$5))*D$5

Either way, the Vlookup portion works okay, as does INDIRECT, but the =
COLUMN stops working when I convert it to an array.

Help is sincerely appreciated!
___________________________
Robert Ades Accountancy Corp.
12100 Wilshire Blvd., Suite 660
Los Angeles, CA 90025=20
Tel:  310-571-1224
Fax:  310-571-1227

robeā€¦@robertades.com

Replies