Hi Everyone! I have a question. I work in an HR office and often have the problem where I have two different spreadsheets with different info that I want on one spreadsheet. At least one column is almost always the same. For example:
spreadsheet 1
EmployeeName......LocationName
---------------------------------
Harry Potter.........Hogwarts
Spreadsheet 2
LocationName......LocationNumber
---------------------------------
Hogwarts............03372
In the example, I'd like to be able to tell excel to pull the LocationNumber cell contents into spreadsheet 1, based on the mutual LocationName column. So if Harry Potter is located at Hogwarts, it would look on spreadsheet 2 for the Hogwarts row and pull in the 03372 LocationNumber from the column next to it to a new 3rd column on spreadsheet 1.
I hope I explained that right. Does anyone know of a formula I could use that would help me accomplish this? I feel like I might be able to do it with some sort of 'if' formula, but I don't have enough of the syntax to figure that out...
Any ideas?
Thanks!
Oh, and I should probably mention that I don't have enough admin access to my computer to install any add-ons or use online software.
Unfortunately I'm stuck with Excel 2013.
Bookmarks