"DLL" wrote:
I really need to use vlookup with rand though. Any input will help.

well, I'm not sure. Guess you could have a go with this:
=VLOOKUP(RAND()*4,{0,1;1,2;2,3;3,4;4,5},2)

You could generate a random integer between 1-5 using simply:
=RANDBETWEEN(1,5)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---