Hi, not sure if this particular issue can be solved or not. I've looked around and seen close to the same problem but not quite.
So for the above table example, what I need to be able to do is lookup a fruit, and have it return the last occurrence two cells to the right.
For example, looking up orange will return 13. Apple will return 20, grape 12 and so on.
Would greatly appreciate any assistance with this.
apple | banana | 1 | 2 |
carrot | orange | 3 | 4 |
banana | carrot | 5 | 6 |
grape | orange | 7 | 8 |
banana | grape | 9 | 12 |
orange | apple | 13 | 20 |
So for the above table example, what I need to be able to do is lookup a fruit, and have it return the last occurrence two cells to the right.
For example, looking up orange will return 13. Apple will return 20, grape 12 and so on.
Would greatly appreciate any assistance with this.