Good morning,
I have the following formula in A1:
=IF(D22="","",HYPERLINK("tel:"&VLOOKUP(D22,TR_Contacts_Data,4,FALSE)))
It looks up the phone number against the chosen contact name from a drop-down list in D22.
Works great - I can click on A1 and it links with Skype and dials the number...