Hi, is it possible to automate a vlookup function in ms excel, if so, how can this be done? Would this require using visual basic? If so, would you know of any sample code to do this? I am a beginner/intermediate user of visual basic...but I would like to improve my knowledge and understanding of excel and visual basic.



Thanks for your contributions?