software

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
One way:

=VLOOKUP(I10, INDIRECT(VLOOKUP(D10, $M$1:$N$9,2)),2,FALSE)

where

M N
1 0.5 Table_A
2 0.74 Table_B
3 ...In article gt;,
Serge gt; wrote:

gt; This formula below works as shown
gt; =IF(D10=0.5,(VLOOKUP(I10,Table_A,2,0))). the result is shown in 'J10'
gt;
gt; But 'D10' has 9 possibilities and 'I10' has to look up 9 tables; Table_A
gt; through Table_I which are in sheet three. for each possibility there is a
gt; table for the answer.
gt;
gt; Can someone help with this please.
gt; Thanks in advance

Thanks for your reply JE,
Does this mean I need to create extra columns?

quot;JE McGimpseyquot; wrote:

gt; One way:
gt;
gt; =VLOOKUP(I10, INDIRECT(VLOOKUP(D10, $M$1:$N$9,2)),2,FALSE)
gt;
gt; where
gt;
gt; M N
gt; 1 0.5 Table_A
gt; 2 0.74 Table_B
gt; 3 ...
gt;
gt;
gt; In article gt;,
gt; Serge gt; wrote:
gt;
gt; gt; This formula below works as shown
gt; gt; =IF(D10=0.5,(VLOOKUP(I10,Table_A,2,0))). the result is shown in 'J10'
gt; gt;
gt; gt; But 'D10' has 9 possibilities and 'I10' has to look up 9 tables; Table_A
gt; gt; through Table_I which are in sheet three. for each possibility there is a
gt; gt; table for the answer.
gt; gt;
gt; gt; Can someone help with this please.
gt; gt; Thanks in advance
gt;

Don't know how your data tables are set up - I suspect you could just
create another table for the lookup...In article gt;,
Serge gt; wrote:

gt; Does this mean I need to create extra columns?

Hello JE,
I tried and failed, would you be interrested in looking at my spread sheet?
Thanks,
Serge

quot;JE McGimpseyquot; wrote:

gt; Don't know how your data tables are set up - I suspect you could just
gt; create another table for the lookup...
gt;
gt;
gt; In article gt;,
gt; Serge gt; wrote:
gt;
gt; gt; Does this mean I need to create extra columns?
gt;

Hello JE,
It's 7:15 pm at home and I finally understood the formula and it works fine.
I'm so happy.
Many thanks again.
I just could not see my way through this without your help.
Serge J.

quot;JE McGimpseyquot; wrote:

gt; Don't know how your data tables are set up - I suspect you could just
gt; create another table for the lookup...
gt;
gt;
gt; In article gt;,
gt; Serge gt; wrote:
gt;
gt; gt; Does this mean I need to create extra columns?
gt;