L
L
Lynatik0012021-07-15 17:12:39
Google Sheets
Lynatik001, 2021-07-15 17:12:39

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

1 answer(s)
A
Alexander Ivanov, 2021-07-23
@Lynatik001

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 IMPORTRANGEto transfer the data to a common place)

=INDEX(IFERROR(VLOOKUP(
  A3:A;
  C3:F;
  {1\2\3\4};
)))

60faf0a49ed00745511197.png
Cell with formula at the link https://docs.google.com/spreadsheets/d/157EFj6LWun...

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question