Re: Productionflow from row to columns

MATCH finds the first hit so can be used to return the row number:
=MATCH("prepare",B1:B10,0)
INDEX gives the nth row of a column, so:
=INDEX(A1:A10,MATCH("prepare",B1:B10,0))
Of course you'd put "prepare" in a separate cell, not in the formula, but you get the idea.