Hi guys,
I have a HLOOKUP that returns a number based on another cell, e.g. "2".
I want to use that within an INDIRECT function for Data Validation so that the list varies depending on the number.
For example when I get "2" from the HLOOKUP I want to get the new list from "Table2[Task Name]".
I have tried various iterations with no luck, can you help?
=INDIRECT("Table"&HLOOKUP(C3,Sheet4!1:3,2,FALSE)&"[Task Name]"&""")
=INDIRECT("Table"&HLOOKUP(C3,Sheet4!1:3,2,FALSE)&"[Task Name]"&"""")
=INDIRECT(CHAR(34)&"Table"&HLOOKUP(C3,Sheet4!1:3,2,FALSE)&"[Task Name]"&CHAR(34))
Can you let me know what I am doing wrong please?
Bookmarks