Matching 4 columns in excel

Closed
erikdemeijer Posts 1 Registration date Wednesday August 26, 2009 Status Member Last seen August 27, 2009 - Aug 27, 2009 at 02:39 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Aug 29, 2009 at 07:03 AM
Dear reader,

I've a question regarding excel.

In my company we use an ERP package, which contains the number of 'tools' we have in our company.
The system is a mess and counts over 1000+ article numbers.
Now, we have counted the real stock of tools. and these are about 500.

In excel we have now four columns.

1 column 2. column 3. column 4. column
ARTICLE NUMBER STOCK IN SYSTEM ARTICLE NUMBER REAL STOCK

G0514954 0,00 G3505030 8
G0514955 0,00 G4005004 10
G0514956 0,00 G4005006 20
G0514957 0,00 G4005010 10
G0514958 0,00 G4005016 5
G0514959 0,00 G4005017 9

is there a way/formula/script that generates a match between the two article numbers and places the system value and the real value next to each other?

I hope someone can help me

Kind regards,

Erik de Meijer
Netherlands

1 reply

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Aug 29, 2009 at 07:03 AM
use vlookup function
0