I think what you're suggesting will work, but I don't know what it is or how to use it. Here's the whole story, at least as much as pertains to having a random number generated based upon the type of building generated with each building having a different random number range.
I've got a table going, Column B is a random number 1-96 using RANDBETWEEN(1,96). Based on that number Column C outputs what type of building it is using =LOOKUP(B3,{0,1,6,12,18,24,30,36,42,48,54,60,66,72 ,78,84,90,97},{"Check","Office","Restaurant","Arse nal","Single_Family_House","Department_Store","Pol ice_Station","Hardware_Store","Gas Station_/_Garage","Convenience_Store","Factory","Warehouse" ,"Hospital","Fire_Station","Specialty_Retail","Sup ermarket","Drug_Store"}).
Now I need Column D to reference either Column B or C, doesn't matter because they pretty much mean the same thing and Column B just randomly determines what kind it is and Column C actually puts it into text, but base on what Column B or C is, it'll be a different =RANDBETWEEN(n,n) value. Like Office is =RANDBETWEEN(2,16).
By the way, the numerical range for each building type is what I've converted from a dice roll, so =RANDBETWEEN(2,16) is actually the same as rolling 2d8, or two 8-sided dice.
I was actually thinking of using a massive nested =IF() statement for this last part, but that may or may not work. I believe I'd have to have the true_value be the =RANDBETWEEN() value for that building, but I don't know if it'll let me just throw the formula into it.
T. Valko wrote:
Why do not you create a 3 column lookup table like this:1...Office...
02-Nov-09
Why do not you create a 3 column lookup table like this:
1...Office...=RANDBETWEEN(n,n)
7...Kitchen...=RANDBETWEEN(n,n)
13...Diner...=RANDBETWEEN(n,n)
Or, am I not following you?
--
Biff
Microsoft Excel MVP
Previous Posts In This Thread:
EggHeadCafe - Software Developer Portal of Choice
The Guru's Guide To Transact-SQL
http://www.eggheadcafe.com/tutorials...-to-trans.aspx