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.