If XLOOKUP value is blank, return blank

[phoenix12345]

Hi everyone, I have a couple of questions for a formula I'm trying to tweak. The Excel workbook has multiple tabs, with employee names and training expiration dates, and a final template which shows all of that employees training plus their training/expiration dates.

This is an example of one of the cells:

=XLOOKUP(B6,Table1[Employee Name],Table1[Column4],"",0,1)
B6 = a dropdown in the template with the employees name (you select their name here, and the template autofills)
Table1[Employee Name] = the table with employee names on a separate tab
Table1[Column4] = the table with training dates on the same tab as the employee tab
"" = if not found, return a blank value - this does not appear to be working, as I see 0 Jan 00 in those cells
0 = exact match
1 = Perform a search starting at the first item

I have 3 more things I need to do for it to be perfect, but I'm not very good at mixing formulas:
1. Blank values need to actually be blank, not show 0 Jan 00
2. If the cell it's referencing contains a "-", then I also need it to return a blank value
3. All dates need to be subtracting 1 year (cell is referencing an expiration of training date, but I also need the date the training occurred, which is typically 1 year prior to the day)

Below is an example image -

Thank you for your help

 

[DanteAmor]

Try:

=IFERROR(IF(XLOOKUP(B6,Table1[Employee Name],Table1[Column4],"",0,1)=0,"",XLOOKUP(B6,Table1[Employee Name],Table1[Column4],"",0,1)),"")