Hello,
I am really new to formulas, I've always had someone do them for me, but now I am in charge of several trackers.

I am working with a formula that brings dates from a different tab via VLOOKUP, and to avoid errors, I used IFNA when my reference is not found: =IFNA(VLOOKUP(C16,'Clean Activity Report (CTMS)'!J:W,14,FALSE),"Pending")

Now, when my lookup value is found but the col-index-num is empty, I get a 0-Jan-00 result.

where do I add to my formula (IF =0,"Pending") without affecting the other formula that is currently working well? I've tried several diferent things and nothing seems to work.