discrepancy in vlookup function results

Dear all,
I have encountered a problem in using vlookup function.

I have two columns with 65536 rows. When I compare column A with column B the results are different from comparing column B with column A.

However around row number 2400 the results are the same.

Can you advice me how to solve this problem?

Regards

Nazanin

Not without seeing some details.

At a minimum, what are the two VLOOKUP formulas?

Also, what are the values in the columns A and B -- at least some of them?

It might also help if you explain how the values in each column are generated. For example, the formulas, if they are calculated, or a statement that they are constants.

For this problem, it might be better to attach a redacted example Excel file; note: the file, not an image. The devil might be in the details.

It is a little tricky to do that in this forum. In a response, click Go Advanced, then Manage Attachments.

-----

Two possible explanations (wild guesses) come to mind. They assume that you are using VLOOKUP(...,TRUE) in the 4th parameter or the 4th parameter is missing.

1. Column A and B are ordered differently. Both must be in ascending order in order for VLOOKUP(...,TRUE) to work correctly.

2. Column A and B are calculated differently; for example, one might be constants, and the other might be formulas (calculations). Calculations can result in internal binary values that are infinitesimally more or less than the equivalent constant. With VLOOKUP(...,TRUE), that can result in VLOOKUP matching the wrong row, since VLOOKUP matches the largest binary value less than or equal to the first parameter.

Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

For normal conversational replies, try using the QUICK REPLY box below.