I have two sheets. On sheet one I have a column of numbers that indicates what geographic area a person lives in. On sheet two I have a column of numbers and the corresponding geographic areas for each number. I want to create a new column on sheet one that gives the name of the geographic area indicated on sheet 2. I'm presuming I can write a formula for this, but I'm an Excel newbie and have no real idea how to go about this. Any help would be much appreciated!
Bookmarks