lookup between dates and matching critera

[mtangri]

In the attached file,  I have done the following steps

1. Used union to bring data in one sheet.  (Input table and output table)

2. then used the following formula

New  Column 

=if [key1 = key2] and [order placement date]>= [order start] and [order placement date]<= [order end]

then 

[expiry month]

else

0

endif

task:  bring in the expiry dates based on the order placement dates, by looking up 1. product/b/w dates.

I am a beginner user and struggling to get the result, any help will be appreciated. 

[Luke_C]

@mtangri  Can you attach the workflow you've tried building so we can better see the steps you've attempted? 

[mtangri]

Thanks for the quick response, I have added the workflow as well as input/output files.

[atcodedog05 · Accepted solution]

Hi @mtangri 

Is this what you are looking for 

Hope this helps : )

[mtangri]

Thanks a lot. it works.  

[atcodedog05]

Happy to help : ) @mtangri 

Cheers and have a nice day!