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

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

locate data from a chart by inserting data into a cell
 

Hi Aaron

Just in case your postcode list is not alphabetically sorted, you should add
the 4th argument of False or 0 to Gav's suggestion
=VLOOKUP(A1,Sheet1!A:B,2,0)


--
Regards
Roger Govier



"Gav123" wrote in message
...
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

locate data from a chart by inserting data into a cell
 

Roger,

Good point..I forgot to add that part..

Gav.

"Roger Govier" wrote:

Hi Aaron

Just in case your postcode list is not alphabetically sorted, you should add
the 4th argument of False or 0 to Gav's suggestion
=VLOOKUP(A1,Sheet1!A:B,2,0)


--
Regards
Roger Govier



"Gav123" wrote in message
...
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