Don’t know if this is something simple that could be done outside of any VBA

Is it possible to have a Lookup table of formula’s

Then on xyz lookup and apply the appropriate formula and apply relative to the calling cell.

If that makes sense ?

Sheet 1 does a lookup and returns a result out of sheet 2

Sheet 1 does a lookup out of sheet 3 based on the return result above

and applies the stored formula relative to the calling cell of sheet1

I think It maybe to complex or not possible outside of VBA and I am to rusty and lack the time to pursue a VBA solution hence my question.

Thanks in advance

/paul