Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Multibul matches
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What query isused to add up the credits until it matches a debit? | Excel Worksheet Functions | |||
How do I count number of cels the matches 2 conditions ? | Excel Worksheet Functions | |||
Match function selecting first value it matches on exactly | Excel Worksheet Functions | |||
matches | Excel Discussion (Misc queries) | |||
counting matches | Excel Discussion (Misc queries) |