Formula help

[serge]

I have this formula : =MATCH(A1,INDIRECT("A20:A200"),0)-0

This formula works until digit 9 but when it get to 10 and up I get : #N/A

So my question is what need to be change for this formula to work wit double digits numbers or more ?

Thank you.... Serge.

 

[serge]

Anyone please !!

 

[Richard Schollar]

Hi Serge

I'm afraid I don't understand the question - can you provide an example of where you are using this and what value A1 contains and what values A20:A200 contains? There is nothing inherently limiting about using Match or Indirect so the problem you are seeing suggests simply that the A1 value is not in the lookup range (hence #N/A).

 

[serge]

Thank you Richard for responding but I found the problem I did made a mistake entering the data in my spreadsheet, SORRY.

Regards... Serge.