VLookup to an external Workbook

[don]

Hi can you help me please.

Is it possible to use a Vlookup to find data in a sheet in another
workbook. If so could someone please let me know how.

Many thanks

Don

 

[Don Guillett]

use this idea
=vlookup(a2,[yourworkbook.xls]yourworksheet!$A$6:$C$11

 

[don]

use this idea
=vlookup(a2,[yourworkbook.xls]yourworksheet!$A$6:$C$11

Many thanks

 

[Don Guillett]

hope it helps

--
Don Guillett
SalesAid Software
[email protected]

use this idea
=vlookup(a2,[yourworkbook.xls]yourworksheet!$A$6:$C$11

Many thanks