Adding a If blank statement to a formula

Hello,

I need some assistance adding to the formulas below.

I need to return a blank if the cells are blank.

In the first, if [FORM '#] is blank and in the second if [CR '# / EMP '#] is blank, return a blank.

Normally I do my If (XX="","") but that wasn't working in these.

=IF(OR([@[FORM '#]]={"N/A","Promotion","Shortage","Unreadable"}),"N/A",IF(COUNTIF([FORM '#],[@[FORM '#]])=1,"UNIQUE","DUPLICATE"))

=XLOOKUP([@[CR '# / EMP '#]],Directory[CR '# / EMP '#],Directory[PATRON NAME / EMPLOYEE NAME])

I appreciate any assistance.

Thank you,
Nick

Thanks AliGW, I should know better to always post a sample workbook.

Attached is a sample.

Awesome, thank you 6StringJazzer!