Using INDEX() Returns the content of a cell, specified by row and column offset.
INDEX()
Formula used
=INDEX(W7:AO, , MATCH("Production Completed", W6:AO6, 0))