Formulas and functions

Hi Iam trying to fill individual cells but to do so for example A1 is the input cell i would like the formula to refer to the data validation for the table name and in descending order search for the...