VLookup of two columns to return a result.

Please attached a sample sheet so we can have a better idea of what it looks like.
You can do so by going to the "Go Advanced" button next to Post quick reply.

File is attached thanks...

I still don't get how you'd like to compare...on what basis? I didn't see any similarity on your file between column A and column H. Also, how'd you determine if it's 'Yes', 'No' or 'Missing'

Two different column header names for the same items (pulled from different databases so column headers are different). invntryitm_id (A1) = IF_PART (H1), QtyOnHand (C1) = IF_PHYS_CNT (J1). Looking up parts numbers from each database and when they match comparing the quantity on hand to see if the quantities are the same in both databases. The missing is to see if parts are missing in one database.

This is what I meant ACFHogan!!

In cell A1 where you have 1158, no matter where I look at column H, there's no 1158 at all anywhere in the fields. Yet, on your above example, you have it under 'YES', instead of 'MISSING'.

If my logic is correct, then the attached file that you've given, it should all be 'MISSING'

So sorry for the confusion. There are 20,000 records, I meant the ..... to indicate that thousand of records follow and the ones that said 'Yes' had matching parts numbers and count numbers. The ones that have matching part numbers, but the count numbers are different said "No" and the part numbers that do not have a match said "missing" The above was a representation of the return of 20,000 records. I know that there are more part numbers in the H1 column which was returned from a second database, so hundreds of part numbers are missing in the first database. The counts in the first database should match the second but don't. The idea is to fix our inventory in the first database by finding the differences between the two databases (second database is the most accurate) and doing physical counts.

I think it's best that you give a few samples that have the ones that were 'Yes', 'No' and 'Missing'.

This way, we can actually know how your file looks like. Rather than blindly "assume" your file looks like how you've given to us in the first attachment.

You mention of 1st and 2nd database. I'm assuming that the 1st database is from Column A to Column F and 2nd database is from Column H to Column L? Since you're only doing a vlookup from 1 to another, which one has the most/complete data. Which file/database you'd like to see 'Yes', 'No' and 'Missing'?

Did what I could with the spreadsheet to make it easier to understand. The VLOOKUP formula in G: is shown below. As you can see in the example I am returning the count from B: and get #N/A for non-matching part numbers. with proper labeling I will be a sort better.

=VLOOKUP(E3, $A$1:$B$1300, 2, FALSE)

Put this formula on cell G2 and copy down and see if it's what you're looking for.

=IF(ISERROR(VLOOKUP($E2,$A$2:$B$19,2,0))=TRUE, "Missing", IF(VLOOKUP($E2,$A$2:$B$19,2,0)=$F2, "Yes", IF(VLOOKUP($E2,$A$2:$B$19,2,0)<>$F2, "No", "Incomplete formula")))