Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cross referencing data in Excel
I have 2 data sheets, one is a complete list with contact addresses
and telephone numbers The other is limited to just the company name. I need to add the telephone numbers from the complete list so I can then see if there are any gaps. Each company has a unique reference number and this is present on both sheets. Please can anyone assist me in adding the telephone numbers from the complete sheet to the incomplete listing without having to manually type this data? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cross referencing data in Excel
Depending on your layouts you can probably use vlookup or index(match
On Jan 24, 5:03*am, Rob Fairbrother wrote: I have 2 data sheets, one is a complete list with contact addresses and telephone numbers The other is limited to just the company name. I need to add the telephone numbers from the complete list so I can then see if there are any gaps. Each company has a unique reference number and this is present on both sheets. Please can anyone assist me in adding the telephone numbers from the complete sheet to the incomplete listing without having to manually type this data? Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cross referencing data in Excel
hi Rob,
if column A contains the reference numbers and column F the phone numbers =INDEX(Sheet1!F:F,MATCH(Sheet2!A2,Sheet1!A:A,0)) -- isabelle Le 2012-01-24 06:03, Rob Fairbrother a écrit : I have 2 data sheets, one is a complete list with contact addresses and telephone numbers The other is limited to just the company name. I need to add the telephone numbers from the complete list so I can then see if there are any gaps. Each company has a unique reference number and this is present on both sheets. Please can anyone assist me in adding the telephone numbers from the complete sheet to the incomplete listing without having to manually type this data? Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cross referencing data in Excel
Hi
I have tried to do this, however my experience at this level of excel is poor. Would anyone be able to talk me through this? To assist I have provided the respective column info Sheet 2 (master data sheet) Column I telephone number & Column L Company number Sheet 3 (secondary sheet) I want to copy the telephone numbers from Column I (sheet 2) to comumn I on Sheet 2 where the company number matches (again for ease this is also column L) Can anyone produce the respective forumla for me? I'm using Excel 2003 (i know a little outdated but its what I have at work) Thanks for your assistance Best regards Rob On Jan 24, 1:21*pm, isabelle wrote: hi Rob, if column A contains the reference numbers and column F the phone numbers =INDEX(Sheet1!F:F,MATCH(Sheet2!A2,Sheet1!A:A,0)) -- isabelle Le 2012-01-24 06:03, Rob Fairbrother a écrit : I have 2 data sheets, one is a complete list with contact addresses and telephone numbers The other is limited to just the company name. I need to add the telephone numbers from the complete list so I can then see if there are any gaps. Each company has a unique reference number and this is present on both sheets. Please can anyone assist me in adding the telephone numbers from the complete sheet to the incomplete listing without having to manually type this data? Thanks- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cross referencing data in Excel
Applying Isabelle's formula to your latest description, you would have
this in cell i2 of your Sheet3: =INDEX(Sheet2!i:i,MATCH(L2,Sheet2!L:L,0)) Then copy down as far as you need to. Hope this helps. Pete On Jan 30, 10:06*am, Rob Fairbrother wrote: Hi I have tried to do this, however my experience at this level of excel is poor. Would anyone be able to talk me through this? To assist I have provided the respective column info Sheet 2 (master data sheet) Column I telephone number & Column L Company number Sheet 3 (secondary sheet) I want to copy the telephone numbers from Column I (sheet 2) to comumn I on Sheet 2 where the company number matches (again for ease this is also column L) Can anyone produce the respective forumla for me? I'm using Excel 2003 (i know a little outdated but its what I have at work) Thanks for your assistance Best regards Rob On Jan 24, 1:21*pm, isabelle wrote: hi Rob, if column A contains the reference numbers and column F the phone numbers =INDEX(Sheet1!F:F,MATCH(Sheet2!A2,Sheet1!A:A,0)) -- isabelle Le 2012-01-24 06:03, Rob Fairbrother a écrit : I have 2 data sheets, one is a complete list with contact addresses and telephone numbers The other is limited to just the company name. I need to add the telephone numbers from the complete list so I can then see if there are any gaps. Each company has a unique reference number and this is present on both sheets. Please can anyone assist me in adding the telephone numbers from the complete sheet to the incomplete listing without having to manually type this data? Thanks- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cross referencing, fidning matching data | Excel Worksheet Functions | |||
cross referencing data | Excel Discussion (Misc queries) | |||
Cross-Referencing Data | Excel Discussion (Misc queries) | |||
Cross Referencing Data and Pasting | Excel Discussion (Misc queries) | |||
Cross referencing data across different workbooks | Excel Discussion (Misc queries) |