I am using table to create drop down lists and generally use this formula:However, I wany to create a bunch of column headers and want to use cell A3's contents as the name of the column header to be referenced. I can't seem to get the drop down list to work when trying this :![]()
=INDIRECT("TABLE NAME[HEADER]")
Any ideas on how to make this work in a simple way or what I am doing wrong.![]()
INDIRECT("Ancillary[$A$3]")
Thanks
Bookmarks