K
K
kanemart2020-03-11 16:24:35
Google Sheets
kanemart, 2020-03-11 16:24:35

How to replace by value from another column?

Can you please tell me how to create an alternative to "Find and Replace" in Google Sheets.
Example, there are 2 data types:
101
102
103
And there are surnames Ivanov, Petrov, Sidorov
Each surname has its own number
Ivanov-101, Petrov-102, Sidorov-103.
At the beginning we have only numbers, at the end we need surnames instead of numbers, there is a lot of this data, so doing it by hand is long and difficult.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
Shohruh Shaimardonov, 2020-03-11
@kanemart

Use the VLOOKUP function. How to eat it, understand the documentation

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question