Hi guys I hope some of you excel ninjas could help me out:
Basically I have a drop down menu with diffrent countries: and I have a dropdown list with them sorted, Basically I want a country flag next to selected country.
https://imghost.io/images/2017/02/26/heeeelp.png
It works perfectly for line 4, here is the code I used in formulas: "flagpic" =INDEX(Sheet2!$S$4:$S$6;MATCH(Sheet2!$D$4;Sheet2!$R$4:$R$6;0))
The problem Im having is when I try to add a new "line 5" the flag does not change based on D5 value but d4s value. what can I do to fix this ?
any help i would appricate
Bookmarks