Populate Column Based on Two Matching Columns

[theLOVINGDEAD]

Hey guys,

So what I'm looking to do i pretty simple.

I basically want to populate column T with values corresponding to matching cells in column Y and column X. For example, I would like to first match Q1 to any value that may exist in 973 rows of column Y. Then if there is a match, I would like to narrow the results down by matching C2 to any value that may exist in the 973 rows of column X. Assuming, both of those match I would like to then populate T2 with the corresponding value in column Z.

The image below shows how I would like this to work. You can see that since both values matched, cells in column T have been populated with corresponding values in column Z.

I hope I explained that well enough for you guys to make sense of it!

https://imgur.com/a/Pd0jJ

Thanks in advance!!!