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

[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

[Don Guillett]

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

On Jan 24, 5:03 am, Rob Fairbrother <robfairbroth...@googlemail.com>
wrote:

[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

> > Thanks- Hide quoted text -
>
> - Show quoted text -

[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

On Jan 30, 10:06 am, Rob Fairbrother <robfairbroth...@googlemail.com>
wrote:

> > - Show quoted text -- Hide quoted text -