Forum Discussion
Solved
XLOOKUP IN LIST OPTION OF DATA VALIDATION
PC/Windows 10/Excel 365 This appears to be a simple issue with a simple solution - then again, there may be no solution. Been trying to understand for some time why it doesn't work. Consequently, ...
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))
You forgot to wrap the INDIRECT() around your xlookup formula:
=INDIRECT(XLOOKUP($C5,DOW,DOWM))
- 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!!!!!!!!!!!!
