Index Array Problem

[JERRY89]

I am using this Index formula =INDEX(Form!B:AA,MATCH(A1,Form!AA:AA,0),13), the problem is A1 is number format but the array AA:AA is not fix, sometime is Text format so is there any formula in excel that i can use to ensure my excel can capture both Number or Text format.

[HansV]

Perhaps

=INDEX(Form!B:AA,MATCH(""&A1,""&Form!AA:AA,0),13)

[JERRY89]

Hi Hans

Is there any typo for the formula,it didn't work.

[HansV]

Could you attach a sample workbook without sensitive data?

[p45cal]

Perhaps try it the other way:
=INDEX(Form!B:AA,MATCH(A1,Form!AA:AA+0,0),13)

[snb]

=INDEX(Form!M:M,MATCH(A1,Form!AA:AA,0))

[JERRY89]

Hi Hans,
Thanks for your assistance.

Hi p45cal/snb,

This formula =INDEX(Form!B:AA,MATCH(A1,Form!AA:AA+0,0),13) have solve my problem, thanks alot