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 -
|