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.
In A2:
=INDEX('Supervisor's Drop-Down'!$A$1:$F$1, MAX(('Supervisor's Drop-Down'!$A$2:$F$51=F2)*COLUMN('Supervisor's Drop-Down'!$A$2:$F$51)))
Fill down.
Thank you HansVogelarr for your amazing quick response. Unfortunately I got the following error after entering the function
I appreciate you for providing me with a possible solution. I'll keep trying you recommendations. Thanks.
Sorry, I should have seen that - you have to double the apostrophe in the sheet name:
=INDEX('Supervisor''s Drop-Down'!$A$1:$F$1, MAX(('Supervisor''s Drop-Down'!$A$2:$F$51=F2)*COLUMN('Supervisor''s Drop-Down'!$A$2:$F$51)))Hi Hans,
Unfortunately it did not work.
After trying your new recommendation, I did do the following change to the Supervisors worksheet:
- Changed worksheet name from "Supervisor's Drop-Down" to "SupervisorDropDown"
