Excel formula using multiple vlooks and ifs in multiple criteria

[Blackpanfer]

I need an Excel formula for a vlookup of a cell in one table to lookup another column in a second table and then do a vlookup of a cell in the second table back to a column in the first table. And I need to do this for muliple criteria.

So if the value coming back from both vlookups for multiple criteria are the same then Yes otherwise No

 

[ExceLoki]

can you give a sample data example of what you're looking for?
also, which version of excel are you using?

 

[Blackpanfer]

I'm trying to verify that the data in each column in yellow on the left from the Xero finance system is the same as the data in yellow on the right in the Sage finance system. I want to match the values from the cells in 3 columns on each side and verify with a yes or no, that they match.

So if the amount, the account code and the date on a row on the right side (SAGE) can be found all on the same row in the columns on the left side (XERO), then YES or NO