autofill formula down based on columns from different worksheet, but skip cell if "FALSE"

I think this may be more what you are looking for :

Formula:

=IF(SUMPRODUCT(ISNUMBER(Sheet1!$A2:$E2)*{1,2,3,4,5})=0,"",INDEX(Sheet1!$A2:$E2,SUMPRODUCT(ISNUMBER(Sheet1!$A2:$E2)*{1,2,3,4,5})))

Drag down

This will find which Friday close has a number in it, and return that, if no number, then blank (**IMPORTANT***--only 1 cell in the row should have a number !!)

Hope this helps