CODEWITHSUNDEEP
excelms-officeformula
maxwell
maxwell

Reputation: 2381

Excel Formula for cross referencing two excel documents

I have a somewhat complicated Vlookup formula that I am trying to write for this particular problem.

I have two excel workbooks dealing with a list of book titles. The only common data column between them is ISBN numbers but one list is much longer i.e. has many more ISBNS than the latter and I suspect that some, if not all, the ISBNS in the smaller workbook are also present in the larger workbook.

What formula should I write to compare the two columns in the separate workbooks so that I can a) immediately identify the ISBNS present in both workbooks and B) know how many are present on both lists and how many are unique?

I hope this makes sense and any help would be greatly appreciated!

Upvotes: 0

Views: 3164

Answers (1)

Ken
Ken

Reputation: 1166

Add a column and use the following formula:

=ISNUMBER(MATCH(A1,H:H,0))

where A1 is an ISBN number, and H:H would be the range that you want to see if the ISBN exists in. It will return TRUE if it exists, and FALSE when it doesn't

Upvotes: 1

Related Questions