| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Table Lookup using two data elements
Hello,
I would like to be able to look up a price depending on both color & count of items. My table looks like: # red blue green black 1-5 .20 .30 .31 .32 6-20 .15 .26 .28 .28 Such that if I ordered 18 blue pens the value returned would be (.26) It seems that I need a combination of both V & H Lookup. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I randomly select data elements from a table? | Excel Discussion (Misc queries) | |||
| Restricting Data Elements in Pivot Table | Excel Worksheet Functions | |||
| Lookup in data table - too many arguments? | Excel Worksheet Functions | |||
| MS Dialog 5.0 sheets - Accessing data elements of objects | Excel Worksheet Functions | |||
| What is the maximum allowed number of data elements in a data array? | Excel Discussion (Misc queries) | |||
Threaded Mode
