Lookup considering the Month

Options
Luis98
Luis98 Member, ALL USERS Posts: 5 Occasional Contributor

Hello, 

I have a Price List named "Raw Materials Price", and I need to pull from "Component Cost Increase" module the % increase by Component, Plant and Period (Jan 2021), hoy can I consider the period in the lookup formula?

Raw Material Price List:

Luis98_0-1630427226750.png

Formula:

Luis98_1-1630427305289.png

Component Cost Increase Module:

Luis98_2-1630427543685.png

 

 

Thanks, regards