INDIRECT for Data Validation List, with embedded LOOKUP

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?

Please try.
=INDIRECT("'Table"&HLOOKUP(C3,Sheet4!1:3,2,FALSE)&"[Task Name]'")

Regards.