Hi guys need help with the following
Trying to do like a lookup or something .
i have 2 documents
Doc 1 is my main document what i am trying to do is.
Get the info from document 2 to document 1 in the correct line.
So i need excel to do the following
If b1(doc1)= Colum a(doc2) there is like 9000 lines
And a2(doc1)= Colum b(doc2) Again around 9000 lines
The input Colum d(doc2) into colum c (doc1)

Can this be donE?
The reason i need it to match 2 things is there could be 2 items the
same but diffrent letters in Colum a (doc 2)

Any help would be great


dOC 1

A B C D E
1 ITEMS AB
2 CKO Stock ON HAND MIN CUST ORD
3 42P100CX 25 25 5


doc 2

A B C D E
1
2 WWHS WPROD IMIN SOH01
3 AB RAS-13UKH-E3 1 0 0
4 AB RAS-13UAH-E3 1 0 0