How to utilize a cell will remain blank but a formula is still required to identify t

I think it might be better if your friend joined the forum and asked the question himself.

If you don't know Excel very well, you may not present the question as well as it might be and may not fully understand any solution proposed.

It would help if you, or your friend, uploaded a sample workbook explaining the problem in context.

Regards