VLOOKUP Based on Name and Date
Hello,
I am having some trouble with a query allowing me to look up values based on the name of an individual AND within a certain date range.
The data table is weekly updated with new values, and has multiple fields, including name, date and comments.
I need to pull a comments field, based on name and date.
Thank you in advance!
Comments
-
Hello @Art Kliatchko
Could you use an if statement to determine if it is within a date range and then if true apply the vlookup here is a rough interpretation
=if(and(first date range field< Date, Second Date Range Field >Date),vlookup(Name Field, Vlookup range, # of Column, False), “N/A”)
Michael
-
Try looking into an INDEX/COLLECT.
=INDEX({range to pull from}, {1st criteria range}, 1st_criteria, {second criteria range}, 2nd_criteria), 1)
Categories
- All Categories
- 14 Welcome to the Community
- 10.8K Get Help
- 65 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives