How to check if a row exists in a different table?

[Bimas]

Hello,

I'm new to the forum, and I come with a question.

I am working with 2 sprea sheets which contain a list with collumns: program, Implementation notes, version, and description.

One of the list is more recent, and thus, the older version is missing some of the rows in the newer one.

I am trying to come up with a formula to check, based on Program, Implementation notes, and version (since description is now different), which rows are in the older spreadsheet, and which rows are missing.

Any ideas?

Thank you

 

[obiron]

As you have probably discovered VLOOKUP() will only work on a single field. One option would be to concatenate the data into a single field and use VLOOKUP but you would need to do this in both workbooks. Alternatively you could use the COUNTIF() function which is more elegant but more difficult to understand and debug. I would suggest using the VLOOKUP() to identify the rows and then replace it with the COUNTIF() logic and confirm that they return the same results, then remove the VLOOKUP(). You could do the same with VBA code and filter the rows in the source sheet and see how many rows remain with the filters; zero rows means that the data is missing.