Re: how do I lookup multiple values

Assumptions:

B1:D1 contains the month

A2:A5 contains the product

B2:D5 contains your data

Formula:

=INDEX(B2:D5,MATCH(G1,A2:A5,0),MATCH(H1,B1:D1,0))

....where G1 contains the product of interest, and H1 contains the month
of interest.

Hope this helps!

In article <61CB16DF-A6D9-40A8-AAF6-F98B801E0D60@xxxxxxxxxxxxx>,
"Lisa" <Lisa@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

> Trying to lookup a value based on both Horizon and Vertical columnsâ?¦.
>
> A B C
> 1 JAN FEB MAR
> 2 Ice-cream .5 .6 .7
> 3 Hot Cocoa 1.0 1.1 1.25
> 4 Coffee 1.5 1.3 1.0
> 5 Soda .8 .6 .9
>
>
> How do I look up the price of ice - cream in the month of Jan. or lookup the
> price of coffee in Mar based on an input from user on both product and month?
>
> I canâ??t figure out which function to use. Please advice.
.

Relevant Pages

  • Re: Problem with Exporting Survey Results to Excel Spreadsheet
    ... Please advice on ... Price? ... > separate columns if you are interested ... Prev by Date: ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Getting Depressed About eBay. Advice?
    ... Honestly the best advice is just buy what you want from Frenchy! ... can't beat him for price, service and he throws in extras and always a ... Prev by Date: ...
    (alt.smokers.pipes)
  • Re: Canon PowerShot A610
    ... Jesse wrote: ... > Can someone give some advice about A610? ... > The current price of A610 is $299. ... Prev by Date: ...
    (rec.photo.digital)
  • BC--DVD
    ... By the way--did anyone pick up the DVD yesterday? ... Any advice on the where to find the best price? ... Prev by Date: ...
    (rec.music.artists.springsteen)
  • Lookup help needed
    ... I'm looking to do a lookup based on a few variables. ... Date Product Location Price ... Sheet "Product A" ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
Quantcast