if formula

[Gary]

Column A, Rows 5-25 has days of the week (mon, tue, thu, etc) based on dates
inserted in Column B, Rows 5-25. The days of the week in A do not appear
unless there is a corresponding date in B.

In Column Y, Rows 5-25 there are days of the week (mon, tue, thu, etc)
permanently typed in.

I wish to put a formula in Column Z, Rows 5-25 that will place a date next
to the corresponding day of the week in Column Y, if the same date appears
anywhere in Column B.

Regards,
Gary

 

[RagDyer]

Would there be more duplicate days in Column B and Column Y?

This *array* formula will return the *first* date that matches the day:


=INDEX(B$5:B$25,MATCH(Y5,TEXT(B$5:B$25,"ddd"),0))

--
Array formulas must be entered with CSE, <Ctrl> <Shift > <Enter>, instead of
the regular <Enter>, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually. Also, you must use CSE when
revising the formula.

Copy down as needed.

Format Column Z to dates.