Re: Using VLOOKUP in an array
From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 05/18/04
- Next message: firefytr: "Re: I want to see the code in a password protected add-in...how to crack?"
- Previous message: Don Guillett: "Re: I want to see the code in a password protected add-in...how to crack?"
- In reply to: Robert A: "Re: Using VLOOKUP in an array"
- Next in thread: Peo Sjoblom: "Re: Using VLOOKUP in an array"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 18 May 2004 18:47:51 +0200
Hi Robert
I'm quite sure SUMPRODUCT is what you're looking for. If you may post
some example rows of your data (plain text) and describe your expected
result it's easy to derive a SUMPRODUCT formula
-- Regards Frank Kabel Frankfurt, Germany Robert A wrote: > "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. > > For instance, the Returns table has 10 columns, each column > represents a different stock index. The rows in the Returns table > represent a series of years. My array formula looks up one or more > indexes for a given year, and multiplies the individual indexes by an > associated percentage for that index to produce a combined result.. > > "Frank Kabel" <frank.kabel@freenet.de> wrote in message > news:OSkKsOPPEHA.3348@TK2MSFTNGP09.phx.gbl... >> 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: firefytr: "Re: I want to see the code in a password protected add-in...how to crack?"
- Previous message: Don Guillett: "Re: I want to see the code in a password protected add-in...how to crack?"
- In reply to: Robert A: "Re: Using VLOOKUP in an array"
- Next in thread: Peo Sjoblom: "Re: Using VLOOKUP in an array"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
