How to match data from two excel tables by matching one column?

Question

Macros

I have two sheets in excel.
Each sheet has two columns.

The set of values ​​for the first columns of both documents is the same, but they are sorted differently (this is a German dictionary, one sheet by topic and the other by alphabet).

In the second column of each document there is a translation of these words, in one sheet in English, and in the other - in Russian. How can I create a file where the match is "German - Russian", but the word

order is the same as in the file "German-English"

words from the second sheet.

EXAMPLE:

Sehen to see | Bluten bleed
Essen to eat | Sehen see
Bluten to bleed | Essen is

What you need to get:

Sehen see
Essen eat
Bluten bleed

That is, sort the ENTIRE SECOND list according to the corresponding FIRST columns.
Help please, who understands) I tried both conditional formatting and writing some kind of formula, but it doesn’t work out (

Answer 1

It will suit you, KMK, the VLOOKUP function.