I am using M1 macbook and am trying to create a drop-down list using an existing table that is named by excel keeps on showing that there is a problem with the formula. Is there anything I have done wrongly or does macbook not support this function?
What I have done:
1. Create a table
2. Change the name of the table
I have attached the excel & inserted a picture of what I want & what error I have.
Thanks for the help in advance!
Forum Version.xlsx
Bookmarks