Thread
:
Depedent Dropdown and INDIRECT($P$8) with a twist
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Claus Busch
external usenet poster
Posts: 3,872
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
Reply With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch