Forum Discussion
syntrax
Apr 24, 2020Copper Contributor
VLOOKUP problem
Hello, I have a problem with VLOOKUP formula. I want to use it to transfer the data from one table to another for specific data. When I use formula some of my cells give me proper data, but some of t...
- Apr 24, 2020
I'd recommend to use Exact match mode for VLOOKUP (4th parameter is FALSE) instead of default approximate match. Plus be sure you have no extra spaces in positions names.
SergeiBaklan
Apr 24, 2020Diamond Contributor
I'd recommend to use Exact match mode for VLOOKUP (4th parameter is FALSE) instead of default approximate match. Plus be sure you have no extra spaces in positions names.
- syntraxApr 24, 2020Copper Contributor
SergeiBaklan Ok, that helps, thank you very much for quick response.
- SergeiBaklanApr 24, 2020Diamond Contributor
syntrax , you are welcome, glad to help