i have a magic table..... file attached

magic table.jpg

i also have to cells which have data validation on the x axis and y axis.

can excel select a value from the table based upon the data validation selected ??