SOLVED

Vlookup can not find match from table

Copper Contributor

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 (Copper Contributor)
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)

1 best response

Accepted Solutions
best response confirmed by kakha11 (Copper Contributor)