Pick Match not working

[mangukiyam]

=Pick(Match(vwaterfallDim, 'R1','C1','L1','C2')+1,
BUDesc,RegionDesc,CountryDesc,LocationIDDesc,GroundDesc)

[Aurelien_Martinez]

Hi,

If you try:

=Pick(Match('$(vwaterfallDim)', 'R1','C1','L1','C2')+1,
BUDesc,RegionDesc,CountryDesc,LocationIDDesc,GroundDesc)

Aurélien

[mangukiyam]

Thank you, It worked