In the event the range_lookup argument is fake—and VLOOKUP is struggling to find a precise match inside your details—it returns the #N/A mistake.INDEX and MATCH may be used to lookup values in almost any column. In contrast to VLOOKUP—in which you could only search for to a worth in the main column within a table—INDEX and MATCH will work