Lookup #NA

[Crixus]

I am struggling to find a solution to a formula returning #NA.

I understand that the cell reference insertion is the issue as I can change it to a numerical value and the formula works perfectly.

However, as the cell value will change regularly, its actual value cannot be inserted.

current formula :

=INDEX(T2:T752,MATCH(N29,S2:S752,FALSE),1)

The cell value in question is 'N29'.

Is there a solution to this?

 

[Andrew Poulsom]

Welcome to the Board.

Maybe try:

=INDEX(T2:T752,MATCH(N29+0,S2:S752,FALSE),1)

More possibilities here:

http://www.contextures.com/xlFunctions03.html#Trouble