LOOKUP([_Thisrow].[Email],"Employee","Email","Name")

---------------------
  
LOOKUP([_THISROW].[Product ID],"Room DATA","Room ID","Room Photo")

----------

LOOKUP([_Thisrow].[hotel name],"hotel","hotel id","location")

-----------
  
LOOKUP([_Thisrow].[room],"room_type","room id","calendarId")