Question on UDF LookUpConcat

[Elwood12]

Hi Rick,

As I posted on Oscar's forum, I'm trying to search for data using multiple criteria, and then concatenate the results. Please see the attachment for a sample. The end result is sort of like a pivot table, except that I want actual values, not summary data, and the return of multiple values if there are any.

So for example in cell C7, I need to search columns I and J for the event that is taking place on 10/9 (the value in C6) in Room 1 (the value in A7). The Macro should return "10a-12p Lunch", as well as "1p-4p Breakout" in the same cell, ideally one on top of each other as of you were using Alt-Enter.

Again in cell D8, the function would search for the value in D6 and A8 to find "6p-11:59 TearDown".

I don't understand how to set this to lookup in multiple ranges, as I would using an INDEX MATCH type formula.

Thank you for your help!