Hello
Can you tell me please why I get a VALUE error for the below?
=FILTER(INDEX('detail'!$1:$1,0,MATCH(JDM2,'detail'!$1:$1,0)),('detail'!$B:$B=JDP4:JEO4))
I am not sure where the error is.
I want to lookup JDM2 in the first row of 'detail' and then filter this whole column using the condition detail'!$B:$B=JDP4:JEO4.
I also get 'not enough memory to complete calculation' error!
Thanks!
Can you tell me please why I get a VALUE error for the below?
=FILTER(INDEX('detail'!$1:$1,0,MATCH(JDM2,'detail'!$1:$1,0)),('detail'!$B:$B=JDP4:JEO4))
I am not sure where the error is.
I want to lookup JDM2 in the first row of 'detail' and then filter this whole column using the condition detail'!$B:$B=JDP4:JEO4.
I also get 'not enough memory to complete calculation' error!
Thanks!