if formula

  • Thread starter Thread starter Gary
  • Start date Start date
G

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
 
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.
 
Back
Top