Dear All,

Trust you're all well.

I am adding a formula into a table column when user type only the YouTube video ID in one cell (on this case, cell M12).

The cell N12 have the following formula and will only show up if value in cell M12 is <> than "":

=IF(M12="","",HYPERLINK(CONCATENATE("https://www.youtube.com/watch?v=",M12),"Open video"))
In the Hyperlink function, we only have the following: HYPERLINK(link_location, [friendly_name])

Is there anyway to add a screentip name based on another cell value?

I see this option only available if adding an Hyperlink manually or through VBA code.

Can we do it in a formula?

Your assistance on this matter will be highly appreciated.

Best regards,
Filipe