Using VLOOKUP wrong?
 

Hey all, I've got 2 columns "A" has names & "B" has percentages. I've
been able to use the VLOOKUP function w/in the same workbook as the
data with success, however when I try to make a new workbook using
VLOOKUP I can't get the formula to work.

Here's what I thought the formula should look like:
=VLOOKUP([Number.xls]Sheet1!$A$2:$A$500="JACK",Number.xls!Test,
2,FALSE)

Can someone please point out my idiocy & get me set on the right
track?

Thanks a ton :)