SOLVED
Home

finding the location of a value in a range of cells

txrussianguy
Contributor

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
Solution
This formula returns 3, which is the position of the word "Test" in the array:
=MATCH("Test",A2:A30,0)
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies