Forum Discussion
XLOOKUP IN LIST OPTION OF DATA VALIDATION
CAROM16 The XLOOKUP formula returns the name of the range that relates to the day of the week. Then you need to wrap it in an INDIRECT function to tell Excel to display the content of that named range and not just the name itself.
Enter the following in the List box and it shall work.
=INDIRECT(XLOOKUP($C5,DOW,DOWM))
CAROM16 The XLOOKUP formula returns the name of the range that relates to the day of the week. Then you need to wrap it in an INDIRECT function to tell Excel to display the content of that named range and not just the name itself.
Enter the following in the List box and it shall work.
=INDIRECT(XLOOKUP($C5,DOW,DOWM))
Riny_van_Eekelen Thank you, Thank you, Thank you !!!!!!!!!!!!! I toiled on this for weeks knowing there had to be a simple solution. I believe I did try the INDIRECT function at some point. Obviously, I must have worded it wrong. It works like a charm now. Thank you, thank you, thank you!!!!!!!!!!!!