pls help sourcing info in formula from cell

sleepers

Board Regular
Joined
May 26, 2004
Messages
203
=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??
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,288
Messages
5,571,321
Members
412,382
Latest member
Langtn02
Top