| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookups with multiple lookup values
If I have a list of products that each come in a different colour and have a
different price, how can I look up the price using both values 'Product' and 'Colour'? ex. A B C 1 Car Red 1000 2 Car Blue 2000 3 Bike Orange 500 4 Bike Red 700 5 Bike Blue 1000 Now, if I have a cell with Car and a cell with Red.... How do I get the corrosponding price? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple lookup values and adding multiple rates across together | Excel Worksheet Functions | |||
| Help with multiple values for a lookup | Excel Worksheet Functions | |||
| Lookup on multiple values | Excel Discussion (Misc queries) | |||
| Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions | |||
| LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied. | Excel Worksheet Functions | |||
Threaded Mode
