
Contributor
2022-08-31
11:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Pick Match not working
=Pick(Match(vwaterfallDim, 'R1','C1','L1','C2')+1,
BUDesc,RegionDesc,CountryDesc,LocationIDDesc,GroundDesc)
691 Views
2 Replies

Partner - Specialist II
2022-08-31
11:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
If you try:
=Pick(Match('$(vwaterfallDim)', 'R1','C1','L1','C2')+1,
BUDesc,RegionDesc,CountryDesc,LocationIDDesc,GroundDesc)
Aurélien
Help users find answers! Don't forget to mark a solution that worked for you!

Contributor
2022-08-31
11:58 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you, It worked
676 Views
