Look up in different sheets

[funniba]

Hi,

I have data in K7:M11 in three sheets namely s_core1,s_core2,s_core3.
The search keys are in A6:C6, A7:B7 and so on.
If A6 is core1, the data in sheet s_core1 should be used to lookup.
If it is core2, the data in sheet s_core2 should be used to lookup.

I don't know the error in the following formula used:

=INDEX(INDIRECT("s_"&A6&"!"&"$K$11:$M$11"),MATCH(C6,INDIRECT("K"&MATCH(B6,INDIRECT("s_"&A6&"!$J$7:$J$9"),0)+6&":M"&MATCH(B6,INDIRECT("s_"&A6&"!$J$7:$J$9"),0)+6),0))

Please help me with that.

Thanks in advance.

[FDibbins]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-form...-up-table.html

Thread Closed.