Hello, I am perplexed. I have a large Excel table based on data imported from Access through a MS Query. That is working fine - however, one column of data filters in showing Employee ID #s. In some cases, there are two employee numbers separated by a semicolon (i.e., 4;7). It is supposed to be like that. I added a column which uses Index/Match to return the names based on ID #. It works fine for the single number items, but I'm not sure how to modify the formula to return results for the two number items.
I am trying to stay away from Vlookup as it was wrought with issues and Index/Match is proving to be more reliable in this situation.
An example of my array table - the last row indicates how I would like results returned with two numbers:
Emp ID # Emp Name
1 EXAMPLE NAME 1
2 EXAMPLE NAME 2
3 EXAMPLE NAME 3
2;3 EXAMPLE NAME 2/EXAMPLE NAME 3
My formula currently looks like this:
=INDEX(EMPLOYEE_NAME,MATCH(LOOKUP_NUMBER,EMP_ID_NUMBER,0))
Could someone explain to me how to modify this? It would be so greatly appreciated. Thank you - Chris
I am trying to stay away from Vlookup as it was wrought with issues and Index/Match is proving to be more reliable in this situation.
An example of my array table - the last row indicates how I would like results returned with two numbers:
Emp ID # Emp Name
1 EXAMPLE NAME 1
2 EXAMPLE NAME 2
3 EXAMPLE NAME 3
2;3 EXAMPLE NAME 2/EXAMPLE NAME 3
My formula currently looks like this:
=INDEX(EMPLOYEE_NAME,MATCH(LOOKUP_NUMBER,EMP_ID_NUMBER,0))
Could someone explain to me how to modify this? It would be so greatly appreciated. Thank you - Chris