In column A of an excel sheet I have a running list of zip codes taken from a sign-in form at an event. In a second excel sheet, I have a list of all zip codes in the state and their corresponding geographic location (zip code in column A, geographic region in column B).
In the first sheet where the sign-in zip codes are stored, I would like to create a formula in column B that searches the second sheet of master zip codes and returns the corresponding geographic location.
Thanks for the help!
Bookmarks