Dependant Validation List Question

[Mister H]

Hi All:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I am hoping that this makes sense to someone...<o></o>
<o></o>
I am trying to create a drop down list that is dependant on other selections. I have it working but there is an issue if one of the cells is blank. Here is the formula that I have in the Data Validation in cell E47<o></o>
<o></o>
=INDIRECT(SUBSTITUTE(E4&B47," ",""))<o></o>
<o></o>
The problem I am having is that if B47 is Blank then then I want there to be nothing showing in the drop down for cell E47 but what is currently happening is the list that appears in B47 is now appearing in E47<o></o>
<o></o>
SO, if this is making sense to anyone I need something like this in my Data Validation Source in cell E47, however it is not working for me.<o></o>
<o></o>
=IF(B47="","", =INDIRECT(SUBSTITUTE(E4&B47," ",""))<o></o>
<o></o>
ANY suggestions? I am new to the Dependant Validation.<o></o>

THANKS,
Mark

 

[Mister H]

Hi:

Just in case anyone actually understood my garblled post I have come up with a solution.

I created another named range called Blank and then entered this formula (Blank is just a single empty cell)

=IF(B47="",Blank,INDIRECT(SUBSTITUTE(E4&B47," ","")))

Probably not the best solution but it seems to work.

Bye 4 Now,
Mark