It works perfectly, except I need to use it in other cell, if I remove the $ around the L3 it stops functioning properly.

I used this formula to build a dynamic list; so based on the Value of Catalyst!$L$3 My list of 972 choices is shrunk into X.

Each row of my main spreadsheet could have a different L3 value needing to be entered.

Help please this is my last step and I have been stuck for a days trying to tweek this.

My Column M is based off the above formula [ =IFERROR(VLOOKUP(ROWS($M$2:M3)|J2:K974|2|0)|"") ]

My data validation for L3 is =OFFSET($M$2|||COUNTIF($M$2:$M$973|"?*"))

Thanks in Advance!!