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