I'm trying to figure how to do the following function (if possible) in Excel.
I have a sheet with a column of names in Column A rows 2 through 100. In column B I have a job title for each of those names. This is my master list.
Each month, I get a random list of containing some of these names, but never all of them and the list does not annotate their title. So, I now have two different sheets and would like to set up a formula that will allow me to auto-populate the job title field of one spreadsheet by looking up the job title for each individual from the master spreadsheet. Is this possible and, if so, how do I do it? I hope this made sense.