software

Trying to lookup a value based on both Horizon and Vertical columns….

ABC
1 JAN FEBMAR
2 Ice-cream.5.6.7
3 Hot Cocoa1.01.11.25
4 Coffee1.51.31.0
5 Soda.8.6.9How 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.=INDEX(B2:10,MATCH(quot;Ice Creamquot;,A2:A10,0),MATCH(quot;Janquot;,B11,0))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

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

B11 contains the month

A2:A5 contains the product

B25 contains your data

Formula:

=INDEX(B25,MATCH(G1,A2:A5,0),MATCH(H1,B11,0))

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

Hope this helps!

In article gt;,
quot;Lisaquot; gt; wrote:

gt; Trying to lookup a value based on both Horizon and Vertical columns….
gt;
gt; ABC
gt; 1 JAN FEBMAR
gt; 2 Ice-cream.5.6.7
gt; 3 Hot Cocoa1.01.11.25
gt; 4 Coffee1.51.31.0
gt; 5 Soda.8.6.9
gt;
gt;
gt; How do I look up the price of ice - cream in the month of Jan. or lookup the
gt; price of coffee in Mar based on an input from user on both product and month?
gt;
gt; I can’t figure out which function to use. Please advice.