Formula Help. Need a Vlookup type formula using multiple data to match

[Fanwood]

Hello to all!

Here is what I need help with and ill use examples:

on sheet1 I have Column A(names) and Column B(address)
on sheet2 I have Column A(names), B(address) and C(city)


if the names and adress match I need it to show C(city) on sheet1. If there is no match then it is left blank.


the names are in no particular order, could be spelled differently or incorrectly, hence the reason to find a match.

thank you

 

[Charlie45]

Did you Change the range? The formula I gave ony goes down to row 500

 

[Fanwood]

Ive tried putting it all the way to 500,000