Look up data

[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

 

[Gord Dibben]

woz

See Debra Dalgleish's site for a VLOOKUP tutorial and a downloadable example
workbook.

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben Excel MVP

 

[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

 

[Dave Peterson]

Look at Debra Dalgleish's site:
http://www.contextures.com/xlFunctions03.html

Example 3 looks pretty close.

 

[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