How to compare two columns and copy the value of the third one if it matches?

Question

excel

Hello.
There are two documents, the first one has a column with the person's full name and an empty column with his date of birth.
The second document has a column with full name and date of birth filled in .

How can dates of birth be transferred to the first document if the second document has a scatter of full names and additional entries that are not in the first document (that is, it simply cannot be sorted).

Answer 1

VLOOKUP function.
In the document in which you need to fill out the DR, enter a function similar to the following:

=впр(%ячейка_где_ФИО%;%диапазон_ячеек_другой_таблицы_из_которой_надо_выдернуть_ДР***%;%номер_столбца_в_диапазоне_где_хранится_ДР%;ЛОЖЬ)

*** in the range, the first column should be where the full name is, then it’s all the same

Example

Answer 2

Paid content - close access with this plugin: WP Pay Access . The subscription will be temporary. Interkassa is there (tab "Payment systems")
Personal messages based on the WP-Recall plugin
and on your own make a selection of those who bought access through WP Pay Access and send via PM (automatically, of course).
those. It doesn't really take much to add. At the time of the publication of the entry, check with her what access it is closed - take from the database a list of users who signed up and programmatically send a PM.
I'm not sure about basic knowledge of php - know api wp, php, mysql.
How to send a message to the chat to the desired user knowing his id - we'll tell you on the plugin support forum.
For mailings, you can use one-way chat - AutoBot Cabinet add-onhttps://codeseller.ru/products/autobot-cabinet/ - it will be in the sender's id.