Forum Discussion
Drop Down list column dynamic
Good morning all, I have a question and I am stumped. So what I am attempting to do is when a div is changed (d) and also the corresponding month (f), then I am wanting to have data placed in...
it appears you are trying to do a LOOKUP function based on month and div from some master table/sheet. This could be accomplished using:
XLOOKUP, VLOOKUP, HLOOKUP, LOOKUP, INDEX(MATCH()), FILTER(), etc
but depends on the particular situation and I'm guessing in your case will require a bit more customization.
if you have a sample workbook with no private information to share that would help.
also, please confirm you have Excel 365 (or not) as that will be very important
XLOOKUP, VLOOKUP, HLOOKUP, LOOKUP, INDEX(MATCH()), FILTER(), etc
but depends on the particular situation and I'm guessing in your case will require a bit more customization.
if you have a sample workbook with no private information to share that would help.
also, please confirm you have Excel 365 (or not) as that will be very important