[Solved] Unexpected result from VLOOKUP

[Binu]

Hi,
I was trying to print an output in "Column C" which is the value in "Column B" that corresponds to the maximum value in "Column A".
Column A is having a same values and blank column also. I was supposed to get the first occurred maximum value and its corresponding value in next column but I got the second occurred maximum. Tried everything that I can, but the result was same. It is giving only the right output only when all the cells in the Column A is having values.
Someone Please help me out in this.

Please find the attached file for reference.

Thanks & Regards,
Binu Varghese

[MrProgrammer]

Column A is having a same values and blank column also.

If you make column A wider you will see that the values of the cells which appear to be 1100 are not the same.
Study [Tutorial] VLOOKUP questions and answers; Q16/A16 explains why VLOOKUP returned 09:00.

202409190927.gif (31.93 KiB) Viewed 1935 times

If this solved your problem please go to your first post use the Edit ☐ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know

[Binu]

Hi,
Thank You for the reply,
Sorry for the error in the attached file, Actually in my case all the values are same, but the thing is that, these values are the output of a formula given in another sheet A, as attached in the new attachment. I am trying to get the max and corresponding value in another sheet and there it is not giving the correct output.

[Alex1]

Widening column C shows:

1000
--
1099.9999999986
1100.0000000022
1099.9999999986

Non-integer decimal values generally cannot be represented exactly in binary. Use one of the rounding functions, e.g.
=IF(A2=B2;"--";ROUND((A2-B2)*1000;0)) in C2.

[Binu]

Hi Alex1 ,

Rounding off helped and it works. Thanks a lot!