Hi everyone,
I'm going to try this one using excel formulas. Here's what I'm working with:
1. Cell A1 contains a value like 12345
2. Range A2:Z2500 contains similar values including value A1
3. Final A1 in A2:Z2500, then return the value to the right of it
For example
Within range A2:Z2500, if cell W1562 contains value 12345 (as found in A1), then return the value in X1562.
Any ideas?
Thanks!!
Bookmarks