Re: Using VLOOKUP in an array

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 05/18/04

Next message: oarmaster: "sorting by street address"
Previous message: firefytr: "Re: I want to see the code in a password protected add-in...how to crack?"
In reply to: Robert A: "Using VLOOKUP in an array"
Next in thread: Robert A: "Re: Using VLOOKUP in an array"
Reply: Robert A: "Re: Using VLOOKUP in an array"
Messages sorted by: [ date ] [ thread ]

Date: Tue, 18 May 2004 18:18:32 +0200

Hi
something like
=SUMPRODUCT(--(Returns=B36),C5:C10,D5:D10)
not sure how 'Returns' is defined but VLOOKUP is definetly not the
correct function for this

--
Regards
Frank Kabel
Frankfurt, Germany
Robert A wrote:
> 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
>
> robert@robertades.com

Next message: oarmaster: "sorting by street address"
Previous message: firefytr: "Re: I want to see the code in a password protected add-in...how to crack?"
In reply to: Robert A: "Using VLOOKUP in an array"
Next in thread: Robert A: "Re: Using VLOOKUP in an array"
Reply: Robert A: "Re: Using VLOOKUP in an array"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: Using VLOOKUP in an array
... "Returns" is a data table for Vlookup. ... I'm attempting to use an array so ... that I can do multiple lookups in the same formula. ... > Robert A wrote: ...
(microsoft.public.excel)
Re: Using VLOOKUP in an array
... I'm quite sure SUMPRODUCT is what you're looking for. ... > "Returns" is a data table for Vlookup. ... > array so that I can do multiple lookups in the same formula. ... >> Robert A wrote: ...
(microsoft.public.excel)
Re: Using VLOOKUP in an array
... Robert A wrote: ... >>> "Returns" is a data table for Vlookup. ... >>> array so that I can do multiple lookups in the same formula. ... My array formula looks up one or more ...
(microsoft.public.excel)
Re: Using VLOOKUP in an array
... Frank Kabel ... Robert Ades wrote: ... > When I use VLOOKUP in an array as follows: ...
(microsoft.public.excel.worksheet.functions)
Re: Using VLOOKUP in an array
... You realize that VLOOKUP can only look up one value in the left most column ... If so you can use this array formula ... "Robert A" wrote in message ... My array formula looks up one or more indexes for a given year, ...
(microsoft.public.excel)