Hello,
I have Column A (City) and Column B (State) in one Tab of my worksheet(Sheet 1) and Column D (City) and Column E (State) in another tab of worksheet (Sheet 2 my data source).
I am trying to do a Vlookup but I need to make sure the city and state in sheet 1 matches the city and state in sheet 2 since I have the same city but in different states.
Any help would greatly be appreciated.
Mike
Bookmarks