Mar 29 2019 04:32 PM - edited Mar 29 2019 05:04 PM
If I have a set of cells (let's say A2:A30), and in A4 I have the word "Test", is there a formula that from another cell, will tell me either:
- BEST CASE: "Test" is in the 3rd position in the array
- STILL USEFUL: "Test" is on row 4
Thanks for any guidance.
Mar 29 2019 11:13 PM
SolutionMar 29 2019 11:13 PM
Solution