Cross referencing data in Excel

[Rob Fairbrother]

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

 

[Don Guillett]

Depending on your layouts you can probably use vlookup or index(match

 

[isabelle]

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 :

 

[Rob Fairbrother]

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

 

[Pete_UK]

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