Excel – Create IF Function from results of a multiple criteria XLOOKUP

How to redeclare formula in if condition

My excel version isn’t 2021 so I can’t use “LET” formula.

Excel: OR function with IF statements

I am working on a Gantt Chart for projects, and need to add different milestones in the calender bar.