G
Guest
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.
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.