View Full Version : Why do I get this Vlookup error?
rsdjimbie
Jul 3, 2012, 03:01 AM
Please refer to attachment. Whenever I lookup value 116%=Error, any other value lookup is then OK?
Thanks.
rsdjimbie
Jul 3, 2012, 03:03 AM
The attachment.
rsdjimbie
Jul 3, 2012, 07:26 AM
Excel version.
JBeaucaire
Jul 3, 2012, 11:37 PM
You're letting cell DISPLAY (formatting) mislead you. The formula in H3 does not equal exactly 116%, but your formatting implies it does.
So two options in H2, fix the H3 value:
=VLOOKUP(ROUND(H3,2),Management!A6:B39,2,FALSE)
.. or let the VLOOKUP do a "fuzzy" match:
=VLOOKUP(H3,Management!A6:B39,2,TRUE)
rsdjimbie
Jul 4, 2012, 12:24 AM
Cool, thanks, will go with the =VLOOKUP(ROUND(H3,2),Management!A6:B39,2,FALSE)
Darkthorne
Oct 22, 2012, 01:31 PM
One other option if nesting within a vlookup is offputting to you would be to change the formula in H3 to below. Your lookup list is based off 2 decimal points
=ROUND(SUM(L5:L6),2)