Extracting data from a page in Excel based on criteria from another workbook

Question

excel

There is an unloading from the database of several hundred thousand rows with many columns, one of which is the full name. There is another (pre-prepared) book with the required list of full names. It is necessary - as easy as possible to leave (or highlight in color) in this unloading only those lines that have a full name from the prepared book.

Answer 1

You can use the same VLOOKUP function.
1) Open both books.
2) On the sheet with unloading from the database, create one more column - "There is in the list". Write the formula:
where instead
of B3 - the cell (on the sheet with unloading from the database) contains the full name
[Last names.xls] - the name of the book with the required list of the full name
Sheet1 - the name of the sheet in the book [Last names.xls]
$A:$A - the name of the column, which lists the required names.
3) The result of the formula will be "True" if such a surname is in the list, and "False" otherwise.
4) Stretch the formula to all lines.
Now you can highlight the desired cells using conditional formatting or filter with a condition.
The list with the required full names must be sorted in ascending order.
Sample: Download from Dropbox

Answer 2

do you own vba? The question can be solved with a simple macro. If the database is really large, then it is necessary to consider pauses in order to give resources to other programs, in this case excel will not freeze - there is a solution for this on the net.
The second option is to dig towards conditional formatting, but I'm not sure about the second one.