E
E
Evgenia Satonina2019-08-08 16:57:41
Google Sheets
Evgenia Satonina, 2019-08-08 16:57:41

How to assign a number to a cell with text in google spreadsheets?

Hello.
I have columns - Model, price -
I want that when you enter a model in a cell in the Model column, a number is automatically substituted - the cost of this model.
That is, assign the text in the cell a specific numeric value. How can I do that?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
N
Noir, 2019-08-08
@PolarBearGG

https://docs.google.com/spreadsheets/d/1rpJjJBX3S0...
via=QUERY($A:$B,"select B where A like '"&$D2&"'",0)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question