How to match multiple criteria from a list to pull entire row from another worksheet?

Dave,

I am definitely still here and I have to say I am definitely seeing the performance issues you were referring to. My original data set goes from A1:AI13129 so the arrays are definitely an issue. I am still trying to make sure I understand the Transpose and why you are doing the "1/(($A2='Raw Data'!$A$2:$A$373)*($B2='Raw Data'!$B$2:$B$373)*('Raw Data'!$C$2:$C$373>=$C2))" as the first part of the INDEX. I am going to try your non array formula and see how that goes and thank you again!