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