Match Names of Reservations Secured with Names of General Inquiries

I have spreadsheet#1 with names of everyone that has requested information (inquiries) on my rental apartments.
Spreadsheet #2 has names of everyone that has secured as reservation (payments).
Spreadsheet#1 also lists the source of the inquiries, but spreadsheet #2 does not.
I want to find out the quantity of reservations by inquiry source.
I would like my payment spreadsheet to have a column next to the guest name that lists the source of that reservation (from spreadsheet #1).

Either of these in M2 of your Payment sheet should do it:

Formula:

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.

It will leave a blank cell if the name cannot be matched.

I plugged in your 1st suggestion & it worked like a dream! I was able to calculate everything I needed to know from there. Thank you so much!!