Hi guys, I am using this formula in Excel 2016 [ =IF(ISNUMBER(SEARCH(Catalyst!$L$3|K2))|MAX($J$1:J1)+1|0)] - My Column J
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!!
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!!