In Excel, how can I return the index number for a matching item in an array?
For example, if one column has:
Apple
Pear
Zebra
and I ask for "Pear", the function should return the numeric value 2. If I ask for "Grape", it should return FALSE or #N/A.
None of the spreadsheet functions I researched (Lookup, VLookup, Match) do this.
Match
does exactly what you need. Please share how you've tried it.