Please offer where get an N/A as a result of the following formula:
Sheet1 - where the values from Lookup are being populated.
Column H on Sheet1 - is the ZipCode
'Lookup Tables' - the sheet that has the lookup values
ColumnA - Zip Code
ColumnB - City
Basically - I want to use the zipcode from ColumnH in Sheet1 to match to zipcode in ColumnA from sheet 'Lookup Tables' to return the city located in Column B in 'Lookup Tables'
The city name in Sheet1 is located in ColumnK - where the Vlookup formula is being entrered.
H2 is in Sheet1 where I am trying to populate the from the sheet 'Lookup Tables' - column A to D - rows 1 to 410. In the sheet 'Lookup Tables' column 2 - zip