Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LOCATE DATA IN ONE SHEET AND APPLY ATTACHED DATA TO ANOTHER | Excel Discussion (Misc queries) | |||
Inserting a chart of data into Word | Excel Discussion (Misc queries) | |||
Inserting Data set into chart | Charts and Charting in Excel | |||
how do I locate a cell that provides data to a formula ? | Excel Worksheet Functions | |||
how do I locate a cell that provides data to a formula ? | Excel Worksheet Functions |