Ok... this is a bit confusing but I'll give it a try...

Cell A1 has a formula that returns one of the 3 possible values "M", "N", "P"
Based off of what value is returned to cell A1 I would like to create a drop down list in Cell B1 that is dependent on that value.

I.E.
If "P" is returned then list "P" will become available as a drop down in that list
If "M" is returned then list "M" will become available
etc...

Then based off of the selection from the returned list i would like to use a vlookup which will reference a table on a second page...

I.E.
"P" is in cell A1 and drop down list "P" in cell B1 has had an item in that list selected, cell C1 will return a numerical value based off of that selection based off of the data table in the second sheet...

Clear as mud? Thoughts?