You could maybe point me in the direction of that does the same thing or a guide (i cant find one)

basically need to lookup a text value cell which features at the end of my data and then return a formula from another sheet to go in the box that is completing the lookup.

so i have a sheet with column A having the name of the dataset, then row B, C, D etc would be the formulas I want the lookup to return when column A is matched.

I can only work out how to return values, and not use a formula that works on the active sheet the cell with the formula is in.

is this possible? what functions are best for this