Formula with fields from a Lookup form

Formula with fields from a Lookup form

I need to use 3 fields in a lookup Form in a formula field.... this can only be achieved with a "On Add" or "On Submit" script...  Is there a static way for doing this?