pls help sourcing info in formula from cell

[sleepers]

=IF(ISERROR(J2(INDIRECT($M$13),B7)),"",(J2(INDIRECT($M$13),B7)))

i have 3 scripts in modules.

on my output page i want to be able to select which script sets the page by typing either 1,2,3 in cell J2 and then the formula above will put in either

1=Concatsetdays
2=Concatsetdays2
3=Concatmth

if i type 1 then the first function will fill the page formula in J2 area of formula above

----------------------------------

someone just posted to this and i got an email telling me but when i go to view it - it sais it does not exist. could the person please post response again??

 

[PaddyD]

40 or so views of your post & no replies - I conclude that we can't quite decipher what you mean.

Let me try & guess - are you saying that you;ve got 3 sheets in your file:

Concatsetdays
Concatsetdays2
Concatmth

...that yoiu want to be variables in your formula?

Please post again with a more detailed example.