Filter question

[angleright]

I am trying to filter on a column(column "L",Plan No) with the following formula
=IF(R18="","",FILTER(FILTER($H$2:$N$109,($L$2:$L$109=$R$18),"NOTHING FOUND"),{0,0,0,0,0,0,1}))
the filter returns work great if the cell contains a number and letter but returns nothing if the cell only contains a number. I have the cells formatted as text. I've tried formatting as general and numeric but still get the same results.
the formula is in row w59

 

[angleright]

That worked, thanks a lot for all your effort. I've changed my profile. I suppose that would have saved a lot of grief

 

[Fluff]

You're welcome & thanks for the feedback.

I've changed my profile

It still shows 365, did you forget to press save?