I am struggling to develop a formula to determine which position in an array another field is located. Here is my example:
- The Array of Trans# is 2239, 4539, 4792, 8912, 10394
- I am trying to find a formula that says Trans# 4792 is in position 3, Trans# is in position 1, Trans# 8912 is in position 4, etc.
I can use FIND to tell me the starting position of the string, but cannot figure out to determine which position Trans# is.
Thanks so much in advance.