Please try this formula where E1 = a date (to match column A) and F1 = a text (to match column B).


When you expand the ranges to suit your needs – I would use named ranges for better transparency and easier management – make sure that all 3 ranges are of identical size.

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top