In C1, type =RANDBETWEEN(1,31)
in D1, type =VLOOKUP(C1,$A$1:$B$31,2,FALSE)
In C1, type =RANDBETWEEN(1,31)
in D1, type =VLOOKUP(C1,$A$1:$B$31,2,FALSE)
Alan
Did you debug your code first? http://www.cpearson.com/excel/DebuggingVBA.aspx
Like my answer? Click * below
Database Normalization
Database Principles
Pivot Table Tips
Excel Video Tutorials
SumProduct Video Tutorial
DataPig Access Tutorials
MS Query Tutorial
SQL Tutorial
Posting Permissions
Reply With Quote
Bookmarks