Forum Discussion
Solved
Vlookup can not find match from table
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
| X | Y | =X+Y | Vlookup(X+Y) |
| 67% | 10% | 77% | Pass |
| 54% | 7% | 61% | #N/A |
Table #2
| Vlookup Table | |
| 77% | Pass |
| 61% | Pass |
This will give you the details:
Your workaround:
=VLOOKUP(TRUNC(D4,2),B7:C8,2,0)
1 Reply
This will give you the details:
Your workaround:
=VLOOKUP(TRUNC(D4,2),B7:C8,2,0)