Formula - Looking up Two Values to Return One

Hello and thank you for your help!

I am looking for a formula that would allow me to look at 2 values in one spreadsheet, lookup those two values in another tab, match it to return to one value to confirm that based on those two values, both of my spreadsheet have the right data.

https://docs.google.com/spreadsheets/d/1ggFxFlGDmHHWY5mM1D7OTHwG3eYQvmHJ/edit?usp=sharing&ouid=117467702719264064800&rtpof=true&sd=true for reference.