Nothing wrong with your vlookup formula, other than the extraneous outer
parens. The problem lies in the data that you're trying to match. It looks
like it should match but it doesn't. Could be either text numbers vs real
numbers issue and/or the presence of extra white spaces for text matches
which is throwing things off.

With your data as-is (ie w/o you having to clean/modify the source
data/lookup values), you could try this index/match for more robust results,
normal ENTER to confirm will do:
=IF(LEN(J2)=0,"",INDEX(List!F$2:F$404,MATCH(TRIM(J 2&""),INDEX(TRIM(List!A$2:A$404&""),),0)))
Copy down. Success? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"OverMyHead" wrote:
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.