Rama Krishnan
Reputation: 39
Excel lookup list of date in sheet,
I have 2 sheet in excel and Second sheet have list of date. We need to lookup all the list of date and compare than today() date. Take first greater than date and get the same row another column. Tried below this,
=MATCH(MIN(IF(Sheet3!B2:B67>TODAY(),"",FALSE)),Sheet3!G2:G67,-1)
Upvotes: 0
Views: 31
Answers (1)
Harun24hr
Reputation: 36780
Try below formula
=XLOOKUP(TODAY(),Sheet3!$B$1:$B$15,Sheet3!$C$1:$C$15,,1)
Upvotes: 1
Related Questions
- Excel - how to match a column header with a row header (dates) and return a lookup value in VBA
- lookup on date ranges in google spreadsheet
- How to get excel to match dates and data then return a value
- VBA look up/find value matching a date variable and return the date next to it
- A Lookup of ALL values that match a Date
- Look up to find exact match based on the given date
- Vlookup combined with first following date in list
- Excel - Lookup to return multiple values in between date range
- How do I match a date from a list of dates in Excel?
- Lookup value within Date range