VLOOKUP is finding partial matches when I only want complete match

I have a large spreadsheet in which I am trying to use VLOOKUP. The formula is matching partial matches when I want it to only return a complete match. For instance my criteria cell contains N322F. VLOOKUP is matching it with N322FJ in my array, when I want it only to match N322F.

Any clues? Thanks.

Tools>Options>Calc>Calculate
Turn off pattern matching (wildcards and regex)
Search criteria = and <> apply to whole cell = On

1 Like

Set the 4th Argument:

=VLOOKUP( … ; … ; …; 0)

Thanks! Clicking “Search criteria = and <> apply to whole cell = On” fixed it.