XLOOKUP - Hide data in cells not yet looking up

As you can tell, I'm working on excel sheets and I'm a complete n00b, but some things are starting to make sense (somewhat).

From the attached, I am dabbling in XLOOKUP. But, On "Sheet1" the xlookup is bringing back a date of '00/01/1900' as I know there is no data for it to refer to, can I get this become a blank cell but still have the xlookup in the cell?

Also, the other cells in row 2 are bringing back "0" and I'd like for that to bring a blank cell back instead of "0" too?

Hope that makes sense, it's getting late here and I've had my face buried in excel sheets all day.

How about

Formula:

Please Login or Register  to view this content.

I would also suggest you update your profile, as 2007 does not have Xlookup.

Thank you so much, solved that headache I was having.

And updated lol thanks.

Glad to help & thanks for the feedback.