Hi Guys,

i have formula which i am trying to input into validation list drop down:

=INDEX(PivotHelpful!D2:D15;MATCH($A2;PivotHelpful!$C$2:$C$15;0);1):INDEX(PivotHelpful!$D$2:$D$15;MATCH($A2;PivotHelpful!$C$2:$C$15;1);1)
what i am getting is :

"You may not use reference operators (such as unions, intersections, and ranges) or array constants for conditional formatting criteria"

as i wrote i can not use constant arary and i should have delimeted list.
How can i do this with my formula ?

Can anybody help?

Jacek