finding the location of a value in a range of cells


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.

1 Reply
This formula returns 3, which is the position of the word "Test" in the array:
Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
205 Replies