Forum Discussion
Excel formula for dynamic drop down list.
I need assistance on the attached question. I have tried all I could but all to no avail.
I am to write a formula in column L4:L15 that will update automatically as column I3 is changed or modified.
Thank you for your support.
I used "good-old" INDEX and MATCH in K4 and copied it down. Then, I also added data validation to I3.
=INDEX($B$4:$F$15,MATCH(K4,$A$4:$A$15,0),MATCH($I$3,$B$3:$F$3,0))In case you are an MS365 subscriber, you'll have more options like XLOOKUP, of FILTER, but the above-mentioned formula works all all Excel versions. File with the formulae attached.
2 Replies
I used "good-old" INDEX and MATCH in K4 and copied it down. Then, I also added data validation to I3.
=INDEX($B$4:$F$15,MATCH(K4,$A$4:$A$15,0),MATCH($I$3,$B$3:$F$3,0))In case you are an MS365 subscriber, you'll have more options like XLOOKUP, of FILTER, but the above-mentioned formula works all all Excel versions. File with the formulae attached.
- Thank you so much I am very grateful for your assistance and for bailing me out.
Your solution work perfectly. You are a live safer.
