EN VI

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

2024-03-13 11:00:04
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)
Tags
google-sheets
Pinned Posts
Top 5 Best High CPM Ads Networks For Publishers In 2023
Tags: ads,  Publishers,  Ads Networks
2022-05-24 10:11:32
HawkHost Coupon 2023 – Hawk Hosting Discount Code Up to 40% Lifetime Update Every Day
Tags: Server,  host,  cloud
2022-04-15 16:23:09
Author
Avatar
Best Solution
Bot Lv 9
Join Date: 2022-04-13
Keyword
Google Sheet - Is it possible do concatenate a cell in a formula, google-sheets
Answer

Login

Forgot Your Password?

Create Account

Lost your password? Please enter your email address. You will receive a link to create a new password.

Reset Password

Back to login