Sheet 1 = 20 000 rows ( Example: All the motor car parts with descriptions)
Sheet 2 = 512 rows. ( Example: only parts for BMW)

Sheet 1 and 2 has a common column that VLOOKUP can search on . ( Example : the Part Number ) BUT thats the only column it has. ( no descriptions)


What I would like to happen is for the data in Sheet 1 to link to Sheet 2 and then produce a sheet 3 with all the values filled in.

( Sheet 3 = 512 BMW Parts / with descriptions)

Any Ideas ?