What you are looking for is an indirect validation

First you name your list range as list and number range as number

Suppose you want to put text 'number' in A1 and the dropdown should appear in B1, then use data validation for B1 and put the formula as =INDIRECT(A1)