Help with a multiple lookup

S

Sal

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
 
B

Bob Phillips

see other post for an example.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Top