Hi Haseeb,

I solved the problem by reformatting the data to a flat format and then used VLOOKUP COLUMNS formula to pull the data.

Thank You for your help, I will look to use this forum in the future.