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.
View best response