Hello everyone. Hope all is well. I am trying to use Index/Match but am not sure if I might be doing it backwards. We cannot use Vlookup. I looked at nested IF statements, but I don't believe it could handle a long list as ours.
I have a list of managers and the branch offices they are responsible for. I.e.:
I have a list of managers and the branch offices they are responsible for. I.e.:
- Manager1 - 20010, 20011, 20012
Manager 2 - 30010, 30011
Manager3 - 40010, 40011, 40012, 40013
Manager4 - 50010
Code:
=INDEX(A16:F25,MATCH(D13,A16:A25,0),1)
- D13 = branch office entered
Column A = Manager Name
Columns B, C, D, E, and F = branch offices