Match names to physical addresses

Hello

I have a list of names and matching address on tab two in the excel sheet example attached. I have a specific list of names on tab one that I need to identify from the list on tab two (along with their addresses). Is there a formula please ?

I have attached an example excel sheet. tab one - specific list of names, tab two - extended list of names and their physical addresses

Could someone please help with this question

thanks kindly

I think you want a combination of columns B and C from the 'addresses' sheet in column C of the 'names' tab?
If that's correct, use either one of these in C2, dragged down:

Formula:

Please Login or Register  to view this content.

Both of them will return, for example: 'ak street, Auckland' for 'joe toe'
Change the ranges as required to match your actual data.

Hope that helps. If I've misunderstood your requirement, please let me/us know.