get table name from cell

[orsm6]

Hi all - is it possible to get the table name using a cell input as the reference?

this is my formula: =FILTER(HART[[Overweight % ]:[Target OW]],HART[Enter SKU]=VISUAL!$F$2,"NO SKU")

how can i change the word HART to the location of the cell, so when the table name changes the formula picks it up?

TIA

 

[orsm6]

So as example - the word HART would be found in cell A1. it is a drop down list for all of the table name sin the workbook.

 

[orsm6]

Hi everyone - sorry i managed to fluke finding a thread containing this answer here.... but for anyone else playing along, this is how i solved it.

=UNIQUE(SORT(FILTER(INDIRECT(A1&"[Enter SKU]"),INDIRECT(A1&"[Enter SKU]")>1),,1))