Calculated Column using Lookup Column, Text Column and Me

Create a calculated column for a calendar that would look like this: =CurrentUser (single line text colum with default value of [Me] + "-" + Selected Value from Absence Type Dropdown - lookup from another list + Selected Value from Location Dropdown - lookup from another list Answer: EventHandler