Ask Experts Questions for FREE Help !
Ask
    rsdjimbie's Avatar
    rsdjimbie Posts: 96, Reputation: 3
    Junior Member
    		  
    #1

    Jul 3, 2012, 03:01 AM
    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.
    rsdjimbie's Avatar
    rsdjimbie Posts: 96, Reputation: 3
    Junior Member
    		  
    #2

    Jul 3, 2012, 03:03 AM
    The attachment.
    Attached Files
  1. File Type: zip Error H2.zip (14.8 KB, 13 views)
    2. rsdjimbie's Avatar
    rsdjimbie Posts: 96, Reputation: 3
    Junior Member
    		  
    #3

    Jul 3, 2012, 07:26 AM
    Excel version.
    Attached Files
  2. File Type: xls Error H2.xls (111.0 KB, 144 views)
    3. JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #4

    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's Avatar
    rsdjimbie Posts: 96, Reputation: 3
    Junior Member
    		  
    #5

    Jul 4, 2012, 12:24 AM
    Cool, thanks, will go with the =VLOOKUP(ROUND(H3,2),Management!A6:B39,2,FALSE)
    Darkthorne's Avatar
    Darkthorne Posts: 4, Reputation: 1
    New Member
    		  
    #6

    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)
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

How to use hyperlink and vlookup [ 1 Answers ]

We get result from the using vlookup but after that I need to go back using the hyperlink on that cell from the results are return.

Vlookup and hlookup [ 1 Answers ]

I want to prafare company payroll where hundreds of employees are working as labours and staff

Vlookup what does that mean. [ 3 Answers ]

Can any one tellme.. what does vlookup formula mean in excel...

View more questions Search