The formula below does a VLOOKUP of A1's value in a table on Sheet2 of a
workbook called Bernard. It works just fine provided Bernard.xls is open

=VLOOKUP(A1,[Bernard.xls]Sheet2!$A$1:$B$10,2,FALSE)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Himansu" wrote in message
...

Hello everyone,

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

--
Thanks,
Himansu