Expression

[#1]

vYear which hold values on the basis of year selection by user like 10,11,12,13,14,15,16...from list box

vValue1,vValue2,vValue3,vValue4,vValue5,vValue6,vValue7 are variable which holds different values.

requirment is like if vYear=10 then vValue1 ,if vYear=11 then vValue2 ,if VYear=12 the vValue3

I tried with pick, Pick(vYear,vValue1,vValue2,vValue3,vValue4,vValue5,vValue6,vValue7)

but did not work , any other way to do it.

[johnw]

Try vYear - 9:

pick(vYear - 9,vValue1,vValue2,...)