Multibul matches

M

Mrbanner

Hi All ,
Need some help with Excel
I have the following 2 excel documents iam trying to link
Now the tricky part
I want a fuction to
Check if c1(doc1) and and a2(a2) match
If they do I then want it to do a second check and see if
A2(doc1 ) and B2(doc2) match if they do I then want it to print the
figure from C(doc2) into b2 (doc1).
There is about 80 lines in Doc 1 going down with 80 item codes
in document 2 there is about 10,000 lines and as seen below there could
be the same item code but with diffrent warehouse codes
Each warehouse has it's own sheet inside excel document.



Doc 1
A B C D E F G
1 ITEMS AB
2 E
3 J
4 Y

Document 2
A B C D
1
2 AB E 4
3 BB E 1
4 AB J 3
5 AB Y 4
6 AB T 5
7 AB J 6
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top