locate data from a chart by inserting data into a cell
Hi Aaron,
You could use a Vlookup function...
in Sheet2 B1 type =VLOOKUP(A1,Sheet1!A:B,2)
Hope this helps,
Gav.
"Aaron Hodson (Coversure)" wrote:
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
|