XLookup Replacement

Hi typod ,

Yes, I would generally say PQ is far easier/faster for this type of thing.

In PQ, all you would need to do is:

1) Import your Sheet1 and Schedule tables

2) Select your Sheet1 table query and go to Home tab > Merge Queries

3) Select you Schedule table from the dropdown at the bottom of the dialog that opens

4) Holding down Ctrl, select the three fields in your Sheet1 table that you want to match to the schedule table

5) Do the same again IN THE SAME ORDER on your Schedule table below (you should see little numbers in the column headers of both table previews showing the selections and the order in which they will be matched)

6) Keep the default Left Outer Merge type

7) Expand the resulting nested-table column, selecting your Schedule[Session] column to expand

Pete