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


--
woz
------------------------------------------------------------------------
woz's Profile: http://www.excelforum.com/member.php...o&userid=28849
View this thread: http://www.excelforum.com/showthread...hreadid=485988

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

On Thu, 17 Nov 2005 13:15:22 -0600, woz
wrote:


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

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),MAT CH(B2,Sheet2!B1:K1,0))

Biff

"woz" wrote in message
...

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


--
woz
------------------------------------------------------------------------
woz's Profile:
http://www.excelforum.com/member.php...o&userid=28849
View this thread: http://www.excelforum.com/showthread...hreadid=485988

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

Example 3 looks pretty close.

woz wrote:

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

--
woz
------------------------------------------------------------------------
woz's Profile: http://www.excelforum.com/member.php...o&userid=28849
View this thread: http://www.excelforum.com/showthread...hreadid=485988

--

Dave Peterson

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


--
woz
------------------------------------------------------------------------
woz's Profile: http://www.excelforum.com/member.php...o&userid=28849
View this thread: http://www.excelforum.com/showthread...hreadid=485988