Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Utilizing a RANDBETWEEN() formula within a LOOKUP formula
I'm trying to make a sheet that'll determine various qualities depending on a
given number, one of those qualities is a randomly determined number within a variety of ranges. For example: If the number is within the range of 1-6 "Office" will be output. From this "Office" output I need the sheet to generate a number in the range of 2-16. The problem I'm having is that I have 16 initial ranges from 1-96 which result in a different type of building being selected. Based on which building is selected, I need the formula to spit out a number from a range that is determined by the type of building. The formula I attempted to use was rather long and still didn't work: LOOKUP(B3,{0,1,6,12,18,24....},{=RANDBETWEEN(1,3), =RANDBETWEEN(2,16),... and so forth. That didn't work and now I'm attempting to use a really long IF statement to achieve the desired effect. Does anyone know how to do this or if EXCEL 2007 is even capable of it? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Formula | Excel Worksheet Functions | |||
Utilizing a Cell even with a Formula located inside it | Excel Worksheet Functions | |||
I: Utilizing non-standard graphs | Charts and Charting in Excel | |||
Lookup Formula | Excel Discussion (Misc queries) | |||
Lookup Formula - but have a formula if it can't find/match a value | Excel Worksheet Functions |