T
TN.Jim
I need to be able to pull a list from series of data without sorting or
filtering...
Example:
A1 B1
Jim Boy
Ann Girl
John Boy
Tina Girl
Then if I Type "Boy" in cell A6,
I can use =index(A1,match(A6,B1:B4,0)) to get "Jim" in A7 but how can I get
John in A8?
The actual list is much more complicated but I hope that this gives an idea
of what I need to do.
Thanks for the help!
Jim
filtering...
Example:
A1 B1
Jim Boy
Ann Girl
John Boy
Tina Girl
Then if I Type "Boy" in cell A6,
I can use =index(A1,match(A6,B1:B4,0)) to get "Jim" in A7 but how can I get
John in A8?
The actual list is much more complicated but I hope that this gives an idea
of what I need to do.
Thanks for the help!
Jim