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!
Last edited by andywozhere; 09-10-2012 at 08:55 AM.
Use VLOOKUP
e.g.
=VLOOKUP(A2,'Sheet2'!A:B,2,0)
copied down.
This looks up the value in A2 of current sheet, finds it in column A of Sheet2, and returns corresponding item from column B.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
That was quick. Thanks very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks