I have some text in A2 and A3.
And in B1 to M1, I have names of sheets (to pick using INDIRECT).
The texts in A2 and A3 are somewhere in the sheets referenced in B1 to M1. Maybe it is in $M$13 in the sheet in B1, and maybe it is in $L$15 in the sheet in C2.
In B2 to M2, I want to know the exact reference of the item in A2 from the sheet referenced in B1 to M1.
In B3 to M3, I want to know the exact reference of the item in A3 from the sheet referenced in B1 to M1.
How can I do that?
And in B1 to M1, I have names of sheets (to pick using INDIRECT).
The texts in A2 and A3 are somewhere in the sheets referenced in B1 to M1. Maybe it is in $M$13 in the sheet in B1, and maybe it is in $L$15 in the sheet in C2.
In B2 to M2, I want to know the exact reference of the item in A2 from the sheet referenced in B1 to M1.
In B3 to M3, I want to know the exact reference of the item in A3 from the sheet referenced in B1 to M1.
How can I do that?
