I have two tables Store Detail and Master
Store Detail
A B C
Division Region Store No.
1B 2134
88 9876
88 5566
...
Master
A B C
Division Region Store No.
10R46 88 5566
10R46 1B 2134
100R91 88 9876
The idea is to get the Division number from the Master for the 'Store Detail' table by Indexing and Matching with Division and Store No. from the Master... I want to add a IF also...so If Region in the Store Detail Table is equal to 88 then put 88 in the Division cell.
I have tried combining the Index(If...),Match() but I keep getting countless errors, how would I go about doing this?
Aucun commentaire:
Enregistrer un commentaire