INDEX, MATCH WITH "&"

[wonderfulsomebody123]

=INDEX(A:A,MATCH("9-"&U29,F:F))

I want the above formula to return a value from column "A" by matching "9-number" from F column.

For example, U29 cell = 135. So 9-135 would be in F:F column and it would give me the data in A column.

Please help. Thanks!

 

[Fluff]

You will get #N/A if there is no exact match, or if you have #N/A errors in col A.