Index/match, Vlookup?
Please see attached sample spreadsheet. I am trying to find the correct formula that will scan the info in 'Test' worksheet and copy the corresponding row of information from 'Test' worksheet to the correct '<Days' worksheet based on the date in Column I. So, if the date in column I is less than 30 days from today, then copy that row to the corresponding sheet, etc. Any help is greatly appreciated.
|