excelmaxvlookup

Excel's max function returning wrong value when using vlookup


In Microsoft Excel 2011 (OSX), I am using the MAX function to obtain the largest value between two cells. The values in these two cells are obtained from other worksheet using VLOOKUP.

This is working fine in most of the rows, except in a couple of situations where the output of the MAX function is the lowest number. If I replace the VLOOKUP function by numbers, it works as expected.

The VLOOKUP formula that I am using is: =VLOOKUP(A43;WorkSheet!$A$6:$C$123;3;FALSE) and the MAX formula is simply =MAX(E43,F43). All cells are formated as Number.

Any suggestions on how to debug this? What might be causing this behavior?


Solution

  • Adding +0 to the end of the VLOOKUP() function as suggested by Barry Houdini in the comments solved my problem.