Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with a multiple lookup
Hi there,
I have a worksheet that contains information on daily sales and I need to look up freight charges from another workbook based on the location and the product type. The locations to look up are in column D and the product types range from Column E to column N (there is a separate entry on each line for each different product type. So in column P I need to write a formula that will take into account both the location and the product type and go to the workbook named Freight Charges and bring back the correct price. I would attach examples but not quite sure how to do that here. Hope someone can help. Much appreciated. S |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup using multiple sheets and multiple criteria, sorry if 2 pos | Excel Worksheet Functions | |||
Lookup using multiple sheets and multiple criteria | Excel Discussion (Misc queries) | |||
Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions | |||
Multiple lookup | Excel Discussion (Misc queries) | |||
Lookup Multiple | Excel Discussion (Misc queries) |