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.