Keyser_Soeze
New Member
- Joined
- Oct 30, 2020
- Messages
- 13
- Office Version
- 365
- Platform
- MacOS
I'd like a formula to return the address of a cell that has a specific value.
The range is A2:AD15 and the value only occurs in one cell in the range.
Something like ADDRESS(MATCH("value",A2:AD15)).
I've been looking through threads about INDEX and MATCH but I can't figure out on how to look for matches in a whole range and not just a single rows or columns.
Thanks!
The range is A2:AD15 and the value only occurs in one cell in the range.
Something like ADDRESS(MATCH("value",A2:AD15)).
I've been looking through threads about INDEX and MATCH but I can't figure out on how to look for matches in a whole range and not just a single rows or columns.
Thanks!