AnsweredAssumed Answered

Extracting values from list based on values in second list

Question asked by laguna92651 on Apr 19, 2017
Latest reply on Apr 21, 2017 by laguna92651

I have two fields with a list in each field, the fields are related, Month and value. Something like this. The months and values are for the last 12 months.

 

Month Names

Feburary 2017¶March¶2017¶April 2017

 

Month Totals

1000¶2000¶1500

 

I would like to extract the Month Totals values based on the corresponding Month Name position and put the values in the correct global monthly bucket, 12 months.

Jan

Feb 1000

Mar 2000

Apr 1500

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Outcomes