Return Multiple Values as a List Using Multiple Criteria

Hey there Haseeb,

With Advanced Filter, I'd be needing to look at the whole table. However, I think I have something like 36 columns, and I just want to return one column's worth of values based on two other columns. Ideally, the massive table could be kept on one sheet and the formula could be implemented on another. I think an array formula would work, just not sure how I'd set it up.

Thanks,
Kevin

Any ideas?