Using Index + filter in Spreadsheets

Question

I would appreciate some help with this spreadsheet issue. I am trying to automate column B to find the next shipment in the restock row and column C to find that same shipment from the same restock row and by using offset to go to the date cell once that next shipment (950) is found. (The table on the right.)

My problem that the formula that I used with the filter function in C2 is giving me an error. However, if in that same formula, I remove the filter (which is set based on date conditions and should start based on today's date in any given date) and I set the range manually, it works fine (see cell C5)

Here it is the link to my sample (here)

Thanks for any help in advance!

Answer 1

I cannot see why you should use index(match()) when filter() seems capable of getting those values directly. Try these formulas:

=iferror( +filter( 
  F$3:$3, 
  not(isblank(F$3:$3)), 
  F$1:$1 >= A10 
) )

=iferror( +filter( 
  F$1:$1, 
  not(isblank(F$3:$3)), 
  F$1:$1 >= A10 
) )

See your sample spreadsheet.