This formula below works as shown
=IF(D10=0.5,(VLOOKUP(I10,Table_A,2,0))). the result is shown in 'J10'

But 'D10' has 9 possibilities and 'I10' has to look up 9 tables; Table_A
through Table_I which are in sheet three. for each possibility there is a
table for the answer.

Can someone help with this please.
Thanks in advance