View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Depedent Dropdown and INDIRECT($P$8) with a twist

Hi Howard,

Am Mon, 16 Dec 2013 00:34:09 -0800 (PST) schrieb :

So if P8 has MATH selected, R8 is working fine using the =INDIRECT($P$8) formula, is there a formula I can use in N8 something like:

="s"&INDIRECT($P$8)
=INDIRECT("s"&$P$8)

to bring sMath to N8. (Neither work)


if I understand you then try in N8:
="s"&P8


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2