Notifications
Clear all
Topic starter
Hi Everyone
I have upload my file i need the look up multi data can any body help me.
Regards/Saliha
Posted : 03/11/2020 8:27 am
I am not 100% sure what you are after as your drop downs are for description and Origin but the yellow fields mention IGST, CST & CGST which are part of the origin.
So i have gone with a 2 way look based on the drop downs
=INDEX($D$3:$F$16,MATCH($I$8,$B$3:$B$16,0),MATCH($I$9,$D$2:$F$2,0))
If this is not what yoiu are after please clarify you question
Posted : 03/11/2020 5:23 pm