We successively introduce new catalytic centers through click reaction into MOFs and modify their environment by addition of lipophilic groups. The resulting bifunctionalized MOF provides an optimized balance between basicity and lipophilicity and shows outstanding performance for the transesterification reaction.