Forum Discussion
Vlookup approximate match giving wrong result
vanilla8910 Decreasing the number of decimals displayed isn't going to help as the numer that is used by Excel in the calculation stays the same. To overcome your problem you need to round the calculation to 0 decimals like this:
in C8: =ROUND(A8/B8,0)
or change the VLOOKUP to this:
=VLOOKUP(ROUND(C8,0),'Lookup table',2,TRUE)
vanilla8910 Decreasing the number of decimals displayed isn't going to help as the numer that is used by Excel in the calculation stays the same. To overcome your problem you need to round the calculation to 0 decimals like this:
in C8: =ROUND(A8/B8,0)
or change the VLOOKUP to this:
=VLOOKUP(ROUND(C8,0),'Lookup table',2,TRUE)
Riny_van_Eekelen thank you so much! that makes perfect sense now I realise the formula bar is still showing 40.2 but the cell is showing 40.
