Answer the question
In order to leave comments, you need to log in
How to merge information from two tables. when there is one common column. it is necessary to transfer the second column in 1 table on the general column?
How to combine information from two tables. when there is 1 common column. it is necessary to transfer the second column in 1 table on the general column?
common column - id - followed by a column with a link to the photo (text) - I need to transfer them accordingly id. who will tell how?
Answer the question
In order to leave comments, you need to log in
You need to use VLOOKUP
For example
A3:A
- the first table,
C3:F
- the second table,
they can be in different sheets or even in different tables (then use IMPORTRANGE
to transfer the data to a common place)
=INDEX(IFERROR(VLOOKUP(
A3:A;
C3:F;
{1\2\3\4};
)))
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question