Should look something like...
=VLOOKUP($A2,'[Testing(1).xls]Sheet1'!$A$2:$B$14,2)
that.

If you're looking up based on column A, and returning results in column B.

Note that VLOOKUP must have the - searched through - column sorted in ascending order to function properly.

mew!