Forum

Notifications
Clear all

Lookup value

2 Posts
2 Users
0 Reactions
70 Views
Md Saliha
(@navsal66)
Posts: 108
Estimable Member
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
(@purfleet)
Posts: 412
Reputable Member
 

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
Share: