Where to put IF(ISNA...

[plank]

Hello,

Can someone help with the following please?:

Im trying to use the IF(ISNA(.. function in this piece of code

Please Login or Register  to view this content.

Im not sure where its supposed to go, as everytime I use it I get the "Runtime error 1004". I would like it to say "Not in data" when no data is available.

Also, in the workbook attached, if you hit the refresh button and there is no value for a certain field in the "Data" sheet, it sets the default to "0", is there a way to leave this blank if there's no value?

Thanks in advance

[plank]

Bump......

[NBVC]

Does this fix it?

Please Login or Register  to view this content.

[plank]

Hello,

Thanks for your response, this doesnt fix it, it clears all the data =/

[Cutter]

Perhaps:

Please Login or Register  to view this content.

[NBVC]

How about?

Please Login or Register  to view this content.

[plank]

Hello,

Thank you both for your help, its no longer showing "#NA". If I wanted to show "Not in data" what should i do?

I think it looks like this, but I keep getting an error:

Please Login or Register  to view this content.

[NBVC]

You have to maintain doubling of double-quotes:

Please Login or Register  to view this content.

[plank]

Thanks so much NBVC!!!

[Cutter]

Thank you both for your help

You're welcome. Thanks for the 'star tap'.