I am trying to get a date from A5:A999 to appear in L3 if the word Fail appears in column K5:k999.
Column A will have a different date in each cell of the column. Column K will either have nothing or the word "Fail" in each cell of the Column. L3 is the target cell I want the date from A5 to appear if the word fail appears in the cell K. There will be five rows like this in a set and each set of five will repeat with a different date in column A and possible blank or fail in column k
A5 B5 C5 D5 E5 F5 G5 H5 I5 J5 K5 L3 9/5/2020 master near gate no no 8.7 0.0 0.0 Fail 9/5/2020
8/20/2020 | Master | 7/31/2020 | Camera | 8/10/2020 | Regular 1 | 8/10/2020 | Regular 2 | 8/20/2020 | Flash | 8/08/2020 | Master | 8/08/2020 | Camera | 8/20/2020 | Regular 1 | 8/20/2020 | Regular 2 | 8/20/2020 | Flash Only |