Forum Discussion
Solved
Auto fill Department column
Good afternoon Microsoft Community, This is my first post ever with this site. I have the following project that I need help with. I need to auto fill the Department in column A in the Raw Data wor...
Thank you. On the RawData sheet, the names are Employee 1, Employee 2 etc., but on the SupervisorsDropdown, they are Employee Name 1, Employee Name 2, etc.
The formula didn't take this discrepancy into account. I changed the names on the RawData sheet, and now it works:
(I modified the formula to return an empty string if there is no match).
See the attached version.
Good morning Hans,
Attached is the actual file I'm using to get this issue resolved. this is a generic file the real file has sensitive information, but the columns and row description are identical. hope this helps.
Thank you. On the RawData sheet, the names are Employee 1, Employee 2 etc., but on the SupervisorsDropdown, they are Employee Name 1, Employee Name 2, etc.
The formula didn't take this discrepancy into account. I changed the names on the RawData sheet, and now it works:
(I modified the formula to return an empty string if there is no match).
See the attached version.
Hi Hans,
I inserted this formula in my real Raw Data file, and it worked perfectly.
thank you for all your help.