formula problem , shown #n/a

[chubbychub]

I have the below formula, I want to show blank or show nothing instead of bunch of #n/a

Please Login or Register  to view this content.

please help , thank you.

[protonLeah]

=IF($H17>$L$1,"", etc.

[chubbychub]

says you have entered an argument that is wrong.

[Phuocam]

Try:

=IFERROR(IF($H17>$L$1,"",INDEX(Table3[Desired Stock],MATCH($H17,Table3[No Color Index],0))),"")

[chubbychub]

it shows in the cell "#NA" now, but no errors, I just want to get rid of all the #n/a that appears.

[sandy666]

so use:

=IFERROR(IFNA(IF($H17>$L$1,"",INDEX(Table3[Desired Stock],MATCH($H17,Table3[No Color Index],0))),""),"")

[chubbychub]

that works, thank you all

[sandy666]

You are welcome

Thanks for the feedback and mark thread solved