Related, Relatedtable, Lookupvale

Hello,   i got a short question: i was trying to build up a relationship between 2 sheets. Since it doesn't work automatically i thought about building a relation via lookup() formula or related()...