Excel how to organize data from two sheets?

Question

excel

There are 2 sheets in Excel
1 sheet
FULL NAME_1 some columns .... ............ ............ .......... . ........... ...........
FULL NAME_2 some columns.... ............ ...... ...... ........... ......................
FULL NAME_3 some columns.... . ...................... ........... ........... ..... .......
Full name_10000000 some columns ........... ............ ............ ... ........ ...........
2 sheet
Full name_1 some column
Full name_3 some column
Full name_7 some column
...
Full name_80 some column
It is necessary to add data to sheet 2 other columns from sheet 1 to get
Full name_1 some column ..... columns from sheet 1 with full name_1....
full name_3 some column ..... columns from sheet 1 with full name_3....
full name_7 some column ..... columns from sheet 1 with full name_7....
...
full name_80 some column ..... columns from sheet 1 with full name_80....
How to do it faster?)

Answer 1

=VLOOKUP(<first_cell_with_name>;<range_from_Sheet_1>;<serial_column_in_range>;FALSE) For
example, like this
=VLOOKUP(A1;Sheet1!$A$1:$C$20;2;FALSE)
and drag the formula down.