| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Look up function for multiple criteria
I have a spreadsheet that has MFG #, Manufacturer, Description and Unit
Price. I need a formula that will look up and match at least the data in 3 columns (MFG #, Manufacturer and Unit Price) in another workbook and bring back the quantity shipped for the row that matches that criteria. Can you help with a formula? Maybe a combination of formula (if that's possible) such as look up MFG #.... and if the manufacturer and unit price match, give me the quantity shipped.... PLEASE help and let me know ASAP if you know the answer :o).... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Criteria for datbase function in one row? | Excel Worksheet Functions | |||
| criteria function using max | Excel Worksheet Functions | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| include criteria to 'rank based array function' | Excel Discussion (Misc queries) | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Threaded Mode
