Call in the Cavalry - 2015

OP wants to do a date-wise lookback across horizontal records. Each record is 1 row by 4 columns. Wants return to show the complete record match. Managed to do this for a single record match, but OP anticipates multiple returns and wants each field to be concatenated. I can’t even set up formula for this one that enables concatenating UDFs to work.

This looks like a job for VBAman … (or CS?)

http://www.excelforum.com/excel-form...d-on-date.html

Edit You can disregard this one. OP has opted to manually concatenate.