How to selectively transfer column values ​​from one file to another?

Question

excel

# First Excel document (1):


# Second Excel document (2):


The task is to match the names of each product and move the three rightmost digits for each row from (2) to (1). If the line in the file (2) is empty, then do not transfer it. The example also shows that products in different documents have different cell indentation.

Answer 1

1. Copy by hand
2. Remove all unnecessary indents, make sure that the number of products matches and match and copy everything at once
3. Use the VLOOKUP function
4. Write a macro that will run in a cycle, match products. It's just not clear in your example how to compare. Just by the value 1000=1000? Well, it's easy.

Answer 2

If you don't know how to use VBA, then try power query