matching and entering data

[MarkyMark]

Hi, will try to explain my problem as best as I can.

I have 2 worksheets. Each worksheet has in column A a list of unique
customer numbers. Sheet 1 has 75000 rows AND 4 extra columns of data and
sheet 2 has 63000 rows. What I need to do in sheet 2 is:

If customer number in Sheet 2 has a corresponding customer number in sheet
1I need to insert the corresponding 4 cells of data aginst the customer
number in sheet 2

also remember the row numbers in sheet 1 & 2 do not correspond!

Please help

 

[Fred Smith]

You probably want Vlookup. Assume your data in Sheet1 is in Columns A:E, use
the following in Sheet2:
=vlookup(a1,Sheet1!A:E,2,false)
=vlookup(a1,Sheet1!A:E,3,false)
=vlookup(a1,Sheet1!A:E,4,false)
=vlookup(a1,Sheet1!A:E,5,false)
and copy down

Regards,
Fred

 

[ryguy7272]

Depending on the arrangement of the data, Vlookup could work for you:
http://www.contextures.com/xlFunctions02.html

If that doesn't give the desired results, try Index/Match:
http://www.contextures.com/xlFunctions03.html

 

[Ashish Mathur]

Hi,

I suspect you will run into performance issues with the standard VLOOKUP()
or INDEX/MATCH(). If that is indeed the case, then you must use Access to
solve the problem (this is a simple case of table joins). Unfortunately, we
would not be able to use MS Query here because MS Query does not recognise
names ranges which span more that 65,000 rows.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com