Having a problem with ISNA

I want to get rid of #N/A from a formula. I can get the formual to eliminate the #N/A but then it won't return a value when it should.

This formula works.

=VLOOKUP($B50,INDIRECT("'"&$B$2&"'!$B$2:$K$43"),3,FALSE)

This is the formula I tried with ISNA.

=IF(ISNA(VLOOKUP($B51,INDIRECT("'"&$B$2&"'!$B$2:$K$43"),3,FALSE)),"",(VLOOKUP($B51,INDIRECT(""&$B$2&"'!$B$2:$K$43"),3,FALSE)))

Jim O

The formula looks OK ... except that you refer to B50 in the first example and B51 in the second.

A sample workbook might help.

Regards

Look at the formula; see the difference?

=IF(ISNA(VLOOKUP($B51,INDIRECT("'"&$B$2&"'!$B$2:$K$43"),3,FALSE)), "",
         VLOOKUP($B51,INDIRECT(""&$B$2&"'!$B$2:$K$43"),3,FALSE))

@shg: hah! eye for detail ;-) missed that ;-(