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

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

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

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 -

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 -