Karen Schaefer
asked on
Index Match not returning correct values
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:
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)
kfsSample.xlsx
ASKER
If the user enters the value (ID) in Col A ManagerID I want the correlated name displayed in Col b and the same for each of the different ID columns.SR_MANAGER_ID col(D)
Col A ManagerID , should return Col(B) - Manager Name
Col(d) - Sr_Manager_ID, should return Col(E) - Sr Manager Name
,DIRECTOR_ID (col F) should return Col(g) - Director Name
Col A ManagerID , should return Col(B) - Manager Name
Col(d) - Sr_Manager_ID, should return Col(E) - Sr Manager Name
,DIRECTOR_ID (col F) should return Col(g) - Director Name
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the great assist, that did the trick.
What IDs/values are you actually trying to lookup?