Hi there,

Apologies if this is a repeat but I cant find my first entry on the
discussion site.

Problem:
I have 2 workbooks. The first contains daily sales figures and I need to
look up freight charges stored on workbook 2 based on 1. Location and 2.
Product type.

Workbook One looks somthing like
Location Prod 1 Prod 2 Prod 3 Prod 4 etc Freight
Auckland 10 Value
determined by Loc & Prod
ChCh 60
Etc

Locations held in column D and products in E:N

I have unsuccesfully tried Index and Match as not really sure what I am
doing. Can anyone please help?

Can email examples if required.

Many thanks for your time.