I feel stupid but I cant figure out what is wrong with my forumla. It will
only return #N/A.

Here is the formula:

=(VLOOKUP(J2,List!$A$1:$G$404,6,FALSE))

Where "List" is another tab on the same workbook and 6 is the column that I
want ito lookup.