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!
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!