bopo
01-13-2007, 06:55 PM
:hi:
Basically I am using a vlookup function to pull info from a spreadsheet, however if I enter a value which doesnt exist, its goes mental and closes. Are they any simple methods to stop this happening, I have consiered a case statments, but though id get the experts opinions first, thanks.
Basically I am using a vlookup function to pull info from a spreadsheet, however if I enter a value which doesnt exist, its goes mental and closes. Are they any simple methods to stop this happening, I have consiered a case statments, but though id get the experts opinions first, thanks.