vlookup woorkbook

[anna]

Is it possible to use VLookup to lookup an external sheet
in a macro?

 

[Don Guillett]

formula
You mean something like this?
=IF(ISNUMBER(D5),VLOOKUP($A5,INDIRECT("Data!B1:X1000"),5,FALSE),"")
or simpler
=VLOOKUP($A5,Data!B1:X1000,5,FALSE)
in a macro
myrng=sheets("Data").range("b1:x100")
msgbox application.vlookup(range("a5"),myrng,5,false)