View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Aaron Hodson \(Coversure\) Aaron Hodson \(Coversure\) is offline
external usenet poster
 
Posts: 46
Default locate data from a chart by inserting data into a cell

Hello,

I have a list of every postcode (column A) in the UK for work in excel
'sheet1'. Each postcode has a rating area A,B or C (column B).

In the next work 'sheet 2' i would like to insert a postcode into A1 and for
the relevant postcode rating to appear in B1.

Could someone please help.

Thanks

Aaron