Need VLOOKUP to Work Two Ways

Jun 7, 2016
Reaction score
Hi everybody. So a few days ago I felt like a genius by getting a set of VLOOKUPs to work properly. I've got one sheet with zip codes, cities, and states, where the city and state auto fills once the zip code is put in. But occasionally the monsters at my place of work will neglect to but their zip codes down. Is there anyway I could type in the city and have the zip and state auto fill as well? Any creative solutions to the problem would be lovely.

The basic set up I have is : Sheet 1 - Column F (ZIP), G (CITY), and H (STATE). And the sheet with the zips, cities, and states are Column A (zip), B (City), and C (State). The formulas on sheet 1 are G " =VLOOKUP(F2,'Zip Codes and CityStates'!A:C,2,FALSE) " and the formula in H is " =VLOOKUP(F2,'Zip Codes and CityStates'!A:C,3,FALSE)

Again, any help or advice would be greatly appreciated!

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question