I am trying to use a VLOOKUP from a large set of data to a smaller set of
data (the array does not contain all of the values being looked up), and thus
returns #N/A.
It works for the first value which is in the table, but as soon as there is
a value missing, all other returns are #N/A as well. Is there any way to get
around these absent values?