harry
Reputation: 11
Search for a particular date in sheet 1 with FROM and TO dates in 2 columns and then paste data from a column in same row in sheet 1 into sheet 2
I am trying to get this formula to work but can't here is link:
https://docs.google.com/spreadsheets/d/1PmUqg-G-TEZhTFj_viqy3XY0KSiJJiVVGDcN8VV57uI/edit?usp=sharing
Array Formula to Lookup Date Between Two Dates:
Master Formula:
=ArrayFormula(IF(LEN(F2:F),(VLOOKUP(F2:F,{row(indirect("A"&A2):indirect("A"&B5)),transpose(split(join("",(rept(C2:C5&"|",(B2:B5-A2:A5)+1))),"|"))},2,FALSE)),))
Upvotes: 1
Views: 244
Answers (1)
Related Questions
- Arrayformula + Vlookup + Date range , how?
- search/match a date on Google Sheets using Google script and copy a source range to a destination range OFFSET from that date
- Match a Date between 2 Worksheets then Copy and Paste Specific Data
- Copy range between sheets, searching for the date in Col-E of OriginalSheet and inserting it between date range of Column A
- How to fill data in excel sheet where date lies between a series of date ranges given in another sheet ? Also, a particular column should match
- In VBA, how do i create a code where it matches dates from 2 sheets and paste data in to that matched date as values? Can't use vlookup for this
- Copy Excel data between sheets based on date & cell value
- Excel vba to scan dates and copy matched elements to the second sheet
- Macro to read cells in one sheet and then search for match in another sheet and add date to column
- Copy/paste Data from 1 sheet to another by matching specific cell or data (Date)