View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
dq dq is offline
external usenet poster
 
Posts: 46
Default dynamic formula? not sure if it's even possible to do this with Excel ...

I think the easiest way is the function 'Indirect'
=INDIRECT(A1&"!B3",TRUE)
If cell A1 is 'Internet' (w/o the quotes) then this will return the
value in cell B3 on that sheet.
To get the name in A1 you can use
=CHOOSE(A2,"Store","Food","Internet")
with A2 being the cell you linked to the option buttons

DQ