Vlookup returns N/A

[bmunoz64]

Hello all,
After desperately trying ti resolve a simple vlookup, I am turning to the forum for help. I have 3 tabs: Conflict Check, Conflict Check Update and Final Table. In cell E2 of the Final Table, I am running the following formulas VLOOKUP(A2, 'Conflict Check'!A:F, 6, FALSE). I am baffled that it returns #N/A. Any idea why?

I am attaching the file for better insight (Cleaned up sensitive data...)

Thanks for the help!

Bruno

[rorya]

The lookup values are in column B of your lookup table sheet, not column A, so you need:

=VLOOKUP(A2, 'Conflict Check'!B:F, 5, FALSE)