I want to include a value from the Datas tab.
So my formula should be : =Datas!A1071.
But how I can use the value include in another my current tab to replace the 1071 part.
Something like this : =Datas!A"B1".
Is is possible ?
Thanks.
>Solution :
You can use the INDIRECT function.
=INDIRECT("Datas!A"&B1)
Or INDEX
=INDEX(Datas!A:A,B1)