Question: why vlookup did not work?
Answer: One constraint of VLOOKUP is that it can only look for values on the left-most column in the table array. If your lookup value is not in the first column of the array, you will see the #N/A error. ... Solution: You can try to fix this by adjusting your VLOOKUP to reference the correct column.