Hi
I have a worksheet that contains legacy data that is being cleaned to
conform to specific formats and conventions. I have another worksheet that
uses this cleaned data to build a new database row. I want to put a drop
down list in my database row worksheet that lists only the cleaned data.

For Example
Column A is the data to be cleaned
Column B contains a formula that tells the end user that the data is OK or
what about the data needs to be cleaned.

ColA ColB
AA12 OK
aa13 Clean Letters
BB03 OK
CC4 Clean Numbers

So my drop down list must contain the content of ColA where the content of
ColB = OK i.e. AA12 and BB03.

I've tried using Debra Daglish's Dependant Drop Down Sorted Lists solution (
http://www.contextures.com/xlDataVal13.html ) with the formula changed so
that the column goes to the left by 1, but as you can see, ColA has the sort.
I get AA12 and aa13 in my drop down list.

I have considered using Debra Daglish's Create Dependant Lists solution
using the INDIRECT function, but if I understand it, every distinct
occurrence in ColB's would have to have it's own named range. I can see that
solution getting rather cumbersome.

Can anyone suggest a solution?

TIA