xlookup with hyperlink if blank

[rjmdc]

what am idoing wrong
this is the fomula
=IFNA(HYPERLINK("mailto:"&IF(ISBLANK(XLOOKUP([@Name],Broker_CM!A:A,Broker_CM!E:E)),"", XLOOKUP([@Name],Broker_CM!A:A,Broker_CM!E:E))),"")
if the paprameter is blank it fills in the mailto:
how do i return a blank cell if no match or @Name is blank

 

[jkpieterse]

=LET(email,XLOOKUP([@name],Broker_CM!A:A,Broker_CM!E:E),IF(ISNA(email),"",IF(LEN(email)>0,HYPERLINK("mailto:"&email),"")))

 

[rjmdc]

hi
i still get mailto: in all cells even if the @Name is blank

 

[jkpieterse]

I've just updated the formula to cater for blanks

 

[rjmdc]

please include formula

 

[rjmdc]

please include formula

wow thats magic
thanks so much