Finding Matching Values from Multiple Columns Based on Criteria

[rmmohan]

I have three lists of data. There is a column of criteria and a column of values. I need to find if a matching value exists in all three columns that has the same criteria.

I have attached a sample spreadsheet. The three lists of data are each in a separate tab. The "compiled" tab is where I want the matching value outputted if it exists. There may not be a value that exists in all three lists.

I really appreciate the help!!