Get the MATCH value index from a range that has number

Given the table below, what formula can I use to return me that the match for a numeric is in index 3?

By thinking, it will be MATCH('is it a number?", A7:A10, 'exact match') = 3

	column A
row 7	abc
row 8	x2y
row 9	105106
row 10	20xb

Solved with array formula

Please Login or Register  to view this content.

Try this ordinary formula:

=MATCH(TRUE,INDEX(ISNUMBER(A7:A10),0),0)