I
I
ihor54332019-04-15 14:22:40
Google
ihor5433, 2019-04-15 14:22:40

Autocorrect values ​​in Google Sheet formulas?

good afternoon everyone! There is such table which parses the data from 3 sites.
5cb466b3c3e2b409716119.png
I have a question! Is it possible to make a replacement immediately in certain places in the formulas.
In this formula, I need to replace "hair" with whatever value I need.
5cb467a4043d9005140063.png
Here are 2 formulas. You also need to replace "hair".
5cb4682a7de1e451313061.png
And the 3rd formula
5cb4687b00dd4589643672.png
Is it possible to somehow choose in each formula the range in which the change should occur?
Because if you use "find and replace", then you must first enter the value to be found, and then a new one. It is not comfortable. And sometimes you forget what value there is and you need to look. need speed.
Tell me please! Is it possible to make it so that I drive a value into a cell and this value automatically replaces in the formulas what I need to change.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander Denisov, 2019-04-15
@ihor5433

There is an idea to make a variable, and change the value of this variable through one of the cells. Post a link to the table, you can not the whole, but at least 3 cells on the screenshots.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question