I'm trying to write a formula that returns a specific date from an array based on two criteria.
Spreadsheet set up:
Row 1 A1:H1 (array of dates)
Row 2 A2:H2 (series of number, 0,4,8,12, etc.)
Column A3:A6 (series of numbers, 0,3,5,8,13,14, etc.)
I want to populate B4:B6 with dates, based on...