How to return names in excel?

Question

excel

There is an exel base in it there are several columns.
I clear 1 column of non-existent addresses and get a list of clean addresses
. T / e I upload the list of exactly email to the service and it also gives me a list.
Now I have a list of emails, how can I insert it into the original table so that the data that was before that, those few columns, are put to these emails.
but only to those that I received after cleaning?

Answer 1

I would give the base a name.
The new (cleared) e-mail list would be inserted on the second sheet of the book.
And the VLOOKUP function would pull data from the database into it.