Trying to accomplish the following:


Have a set of dates as column headers across a worksheet.
Rows are product names.

When a product is delivered, the cell is marked "delivered" for the date (in the column header) it was delivered.

Need a formula that will look across each row (product), and return the date of the first cell with the value "delivered".

I have:

=INDEX(F19:AS19,1,MATCH("delivered",F19:AS19,0)) <for row 19

right now, but its just giving me "delivered" as the value and I cant figure out why.

I dont know if I explained it clearly enough, but any help is vastly appreciated!