SOLVED

Vlookup can not find match from table

%3CLINGO-SUB%20id%3D%22lingo-sub-1139672%22%20slang%3D%22en-US%22%3EVlookup%20can%20not%20find%20match%20from%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1139672%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I've%20met%20a%20issue%20and%20can%20not%20manage%20to%20guess%20what's%20the%20problem.%20I%20wanted%20to%20find%20in%20table%20%231%20X%2BY%20match%20from%20Table%20%232.%20Vlookup%20can%20find%20match%20with%20some%20number%20combination%20and%20struggle%20to%20find%20match%20with%20some.%20You%20can%20also%20find%20attached%20excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20explain%20me%2C%20why%20is%20this%20happening%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETable%20%231%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EX%3C%2FTD%3E%3CTD%3EY%3C%2FTD%3E%3CTD%3E%3DX%2BY%3C%2FTD%3E%3CTD%3EVlookup(X%2BY)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E67%25%3C%2FTD%3E%3CTD%3E10%25%3C%2FTD%3E%3CTD%3E77%25%3C%2FTD%3E%3CTD%3EPass%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E54%25%3C%2FTD%3E%3CTD%3E7%25%3C%2FTD%3E%3CTD%3E61%25%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3ETable%20%232%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EVlookup%20Table%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E77%25%3C%2FTD%3E%3CTD%3EPass%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E61%25%3C%2FTD%3E%3CTD%3EPass%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1139672%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1139752%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookup%20can%20not%20find%20match%20from%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1139752%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F538701%22%20target%3D%22_blank%22%3E%40kakha11%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20will%20give%20you%20the%20details%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fhelp%2F315961%2Fthe-vlookup-and-hlookup-functions-fail-to-find-a-number-in-a-list-in-e%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fhelp%2F315961%2Fthe-vlookup-and-hlookup-functions-fail-to-find-a-number-in-a-list-in-e%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20workaround%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DVLOOKUP(TRUNC(D4%2C2)%2CB7%3AC8%2C2%2C0)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

Hello, I've met a issue and can not manage to guess what's the problem. I wanted to find in table #1 X+Y match from Table #2. Vlookup can find match with some number combination and struggle to find match with some. You can also find attached excel.

 

Can anyone explain me, why is this happening? 

 

Table #1

XY=X+YVlookup(X+Y)
67%10%77%Pass
54%7%61%#N/A

Table #2

Vlookup Table
77%Pass
61%Pass
1 Reply
Best Response confirmed by kakha11 (Visitor)
Solution

@kakha11 

This will give you the details:

https://support.microsoft.com/en-us/help/315961/the-vlookup-and-hlookup-functions-fail-to-find-a-num...

 

Your workaround:

 

=VLOOKUP(TRUNC(D4,2),B7:C8,2,0)