I am attempting to create a xls that allows the user to input a Emp Id under the correct Manager category that will lookup the Manager name for another worksheet. What am I missing. I have included a sample file.
Data extract sheet the user inputs the ID and return the name, except my version is not returning the correct manager name, except for col D:E.
What am I doing wrong:
=IFERROR(INDEX('EMP LIST'!$A:$A,MATCH(1,'EMP LIST'!H2,0)),'EMP LIST'!$B:$B)