mercredi 16 septembre 2020

Excel Nested IF with INDEX & MATCH

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