Output spilling over and I can't seem to fix it
I'm having a problem with a spreadsheet:
In A2:A200 I've got a list of employee names
In C1:H1 I've got a list of departments (Finance, HR, Payroll, Maintenance, Grounds, Housekeeping, etc.) with employees parsed out in their respective columns ('John Smith' in C2 under 'Finance', for example.
I'm trying to get a formula to reference values in the A column vs. where they're listed in the C through H columns and then return the department in the respective B cell (IE "John Smith" in A2 will return "Finance" in B2)
I've tried =IFS(A2=C$2:C$200,"Finance",A2=D$2:D$200,"HR",A2=E$2:E$200,"Payroll") and so on with the remaining logical tests for the other departments but my output keeps spilling into A3 and down, which prevents me from using it in other cells.
I can brute force my way through by putting in each employee and their department manually but I'd rather automate the process to speed it up next time I have to run this report. Any help is appreciated.
Edit: I'm using Office 365 Enterprise
[link] [comments]
Want to read more?
Check out the full article on the original site