Search code examples
google-sheets

Google Sheet - Is it possible do concatenate a cell in a formula

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 ?

Example: https://docs.google.com/spreadsheets/d/1qboMqSbrXLervVQcEAfWpb_HB9m6EPbQxUbmeAZXtiE/edit#gid=1569842665

Thanks.

Solution

  • You can use the INDIRECT function.

    =INDIRECT("Datas!A"&B1)

    Or INDEX

    =INDEX(Datas!A:A,B1)