How to control user input on a multiple drop down lists?

Hi All,

Your help is much appreciated

Intro:
========
I am new this forum and to Excel. I do not understand VB and Macros, I am trying to only use
formulas and functions, if you can help, please make it simple, so I can understand it and use
it to do other things later on, or you risk me writing again and again to the forum :-)

Problem:
=========
I to create a Drop Down List Items, based on an entry made on a previous drop down list, and this
will be done over and over many lists, NOT ONLY TWO, like most examples on the web

on the attached Excel:
====================
Tab = Logic Flow: I mapped the possible scenarios, I added an IF statement as well in the RED and GREEN Cells
Tab = GP Tool: This is the actual tool I wrote, very basic I know

Questions (All related to Tab = GP Tool) :
==================================
Q # 1:
Once the user selects a value in “C3”, I want specific values to show up
in “C5, C7,C9,C11” based on the logic on tab = Logic Flow
The way it is right now, all options are available for the user to pick from
the cells which are not going to have a value, because of the value
selected in C3, would show “N/A”

Q# 2:
If C3=ATB, I want all other cells to show “N/A”, and C16=”N/A”

Q#3:
Is it possible to do it where once C3 is selected, everything else goes blank
till the user makes an actual selection? the way it is right now, if C3 has a new
value, the other cells keep their old value, including C16, which can cause
confusion and lead the user to believe he/she already got the answer


Thanks in advance for your help

BR,

Rashed

looking at the number of views and (0) response makes me think maybe I did not do a good job describing what I am trying to do, here is a second attempt:
Q1. If user select a value in "C3" then only certain values would show up in C5
Based onthe value of C5, only certain values will show up in C7
Based on the value of C7, only certain values will show up in C11
I tried creating name range and use the indirect command, this did not work beyon C7!

Q3:Is it possible to do it where once C3 is selected, everything else goes blank or the other cells (i.e. C5, C7, C11) will turn red to alert the user that he/she needs to input some values before getting the final recommendation

Thanks again for any help/advice you can offer

BR,
Rashed

Thank You FDibbins, the solution you provided is great, but I guess it works only if we check one cell at a time, in my case, I have check multiple cells, since I can not upload documents right now, I will use text only:
Using the example you provided:
B4 = Mammal
C4 =INDIRECT(B4)
D5 =I want to check both B4 & C4 before I decide on which name list I want to use, so if D4 was the number of wings, this field will show N/A,
but if B4=Bird AND C4= bird1, then D4=2
if B4=Bird AND C4= bird2, then D4=4
if B4=Bird AND C4= bird3, then D4=N/A
I found on the internet an example as following: =INDIRECT(SUBSTITUTE(C3&C5," ",""))
I was hoping to use it to look at two cells, and remove the spaces at the same time, but that did nt work!!! I also thought
I can use the same syntax to verify the value of 3 or more cells before make a decision on what name range list to use

Again, your help is much appreciated

Rashed