Forum Discussion

syntrax's avatar
syntrax
Copper Contributor
Apr 24, 2020
Solved

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...
  • SergeiBaklan's avatar
    Apr 24, 2020

    syntrax 

    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.

Resources