All,

I am hoping to populate a column with data from another worksheet.

Basically, I have a set of columns, one for Location, Zip Code, Longitude, and Latitude. I want a formula to say, if the location equals X, then pull the associated information from the other worksheet. Any input would be greatly appreciated -- I assume it would be an if or vlookup, or combination.