Forum Discussion
kakha11
Jan 30, 2020Copper Contributor
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 ...
- Jan 30, 2020
This will give you the details:
Your workaround:
=VLOOKUP(TRUNC(D4,2),B7:C8,2,0)
Patrick2788
Jan 30, 2020Silver Contributor
This will give you the details:
Your workaround:
=VLOOKUP(TRUNC(D4,2),B7:C8,2,0)