Jan 30 2020 05:26 AM
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 |
Jan 30 2020 05:59 AM
SolutionThis will give you the details:
Your workaround:
=VLOOKUP(TRUNC(D4,2),B7:C8,2,0)
Jan 30 2020 05:59 AM
SolutionThis will give you the details:
Your workaround:
=VLOOKUP(TRUNC(D4,2),B7:C8,2,0)