Previous Topic Next Topic

Matching 4 columns in excel

Closed
erikdemeijer Posts 1 Registration date Wednesday 26 August 2009 Status Member Last seen 27 August 2009 - 27 Aug 2009 à 02:39
Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 - 29 Aug 2009 à 07:03
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
Related:

1 response

Réponse 1 / 1
Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 307
29 Aug 2009 à 07:03
use vlookup function