| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I lookup multiple values
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 cant figure out which function to use. Please advice. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to lookup a value and return multiple corresponding values | Excel Worksheet Functions | |||
| Only text values matching using index/match lookup - data type pro | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| How to sum values in multiple worksheets | Excel Worksheet Functions | |||
| Lookup values in a list and return multiple rows of data | Excel Worksheet Functions | |||
Threaded Mode
