Look up data

W

woz

I have a range of data on a work sheet which has letters in column A2 TO
A23 (first 2 letters of the UK postcode). Then in Row 1B to 1K there are
various numbers (Weights) and in the range from B2 to K23 are various
cost prices.
How can I set up a seperate worksheet where I can just enter any 2
letters from Column A and any weight from row 1 and return the correct
result ie. cost??
Any help would greatly appreciated.
Cheers
Woz
 
B

Biff

Hi!

One way:

Assume the table is on Sheet2 and this formula is on another sheet.

A2 = postal code to lookup
B2 = weight
C2 = formula:

=INDEX(Sheet2!B2:K23,MATCH(A2,Sheet2!A2:A23,0),MATCH(B2,Sheet2!B1:K1,0))

Biff
 
W

woz

Hi Dave,
Spot on with that, example 3 works a treat, just need to polish up on
the Index / Match logic and apply.
Cheers
Woz
 
Top