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)....