Thanks for all your help!!!


"Bernard Liengme" wrote in message
...
Use Edit Clear All on the cell in question
Type this much: =VLOOKUP(A4,
The activate the other workbook and use the mouse to select the range
Sheet1!$A:$B
Finish by typing: ,FALSE)
Does it work now?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Himansu" wrote in message
...
Hi Ian,

For some reason this doesn't work:
--

=VLOOKUP(a4,[VFW_Cell_Dept_Matrix.xls]Sheet1!$A:$B,2,false)

--

** The cell doesn't even get treated as a formula inside it....




"IanKR" wrote in message
...
Is it possible to use "vlookup" when comparing ranges in different
workbooks? Let me know what you think. Any examples would be great.

Yes - just fully-reference the table_array range thus:


=VLOOKUP($A2,'[<workbookname.xls]<worksheetname'!$A$4:$G$13,B$12,FALSE)

Is this what you mean?