Ok, I'm sure for someone a lot better with Excel than I am this is easy.
I have a spreadsheet where I have employee names in column A, work locations in column B. I would like to have a third column where their supervisor's name is filled depending on the work location in column B.
Basicially I would like:
<tbody>
</tbody>
And so on and so forth where it would fill column c appropriately based on the contents of the neighboring cell in column B. I do a little coding, so I know I could do this with an if statement, but I don't know how to get that working with Excel.
Thanks in advance
I have a spreadsheet where I have employee names in column A, work locations in column B. I would like to have a third column where their supervisor's name is filled depending on the work location in column B.
Basicially I would like:
A | B | C |
John | North | SUPV A |
Joe | South | SUPV B |
Jack | South | SUPV B |
Janet | North | SUPV A |
Janice | East | SUPV C |
<tbody>
</tbody>
And so on and so forth where it would fill column c appropriately based on the contents of the neighboring cell in column B. I do a little coding, so I know I could do this with an if statement, but I don't know how to get that working with Excel.
Thanks in advance