Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Why do I get this Vlookup error? (https://www.askmehelpdesk.com/showthread.php?t=678265)

  • Jul 3, 2012, 03:01 AM
    rsdjimbie
    Why do I get this Vlookup error?
    Please refer to attachment. Whenever I lookup value 116%=Error, any other value lookup is then OK?
    Thanks.
  • Jul 3, 2012, 03:03 AM
    rsdjimbie
    1 Attachment(s)
    The attachment.
  • Jul 3, 2012, 07:26 AM
    rsdjimbie
    1 Attachment(s)
    Excel version.
  • Jul 3, 2012, 11:37 PM
    JBeaucaire
    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)
  • Jul 4, 2012, 12:24 AM
    rsdjimbie
    Cool, thanks, will go with the =VLOOKUP(ROUND(H3,2),Management!A6:B39,2,FALSE)
  • Oct 22, 2012, 01:31 PM
    Darkthorne
    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)

    • All times are GMT -7. The time now is 04:38 AM.