SOLVED
Lookup using dates across two sources
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
ndani
7 - Meteor
04-06-2021
04:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, I need some help with look up across two source. I am trying to bring the YYYYMO from the right side table if the date in the transactions source falls within the start and end dates in the right side table.
I'd appreciate any guidance. Both the excel sources attached.
Thanks!
Solved! Go to Solution.
Labels:
- Labels:
- Preparation
- Transformation
3 REPLIES 3
21 - Polaris
04-06-2021
05:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@ndani
I hope this helps
04-06-2021
08:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks @Qiu for the prompt reply. This worked great. I appreciate it.
21 - Polaris
04-06-2021
02:45 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@ndani
Happy to help and thanks for the accept mark😁
