Thread: Look up data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
woz
 
Posts: n/a
Default Look up data


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