Thanks!!! that was the problem.....I changed the attributes of the columns
and now it works fine....


"IanKR" wrote in message
...
I tried this:

=VLOOKUP(A4,[VFW_Cell_Dept_Matrix.xls]Sheet1!$A$1:$B$300,2,FALSE)

but I get a N/A when it clearly avaialble...

Check for rogue leading and/or trailing spaces in both the col A values of
the other wkb and also in your A4 value of the first wkb.