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:
> 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 <i...@v.org> 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 -
|
