Need VLOOKUP to Work Two Ways


Joined
Jun 7, 2016
Messages
1
Reaction score
0
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!
 
Ad

Advertisements


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

Top