# Probability in excel using lookup?

#### chasey

##### New Member
hiya can anyone help to do the following , i have a cell called daily sales and i need the numbers bellow to appear in that table according to the probabitity. for example the number 50 will appear in the cell 40% of the time and number 45 will appear 20% of the time and so on, i think i need to use a lookup table but not sure, is this possible in excel if so can someone help me please
thank you

Code:
``````Daily sales	  40     45	    50	55    60

Probability	  10%   20%       40%   25%    5%``````

### Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

#### PA HS Teacher

##### Well-known Member
Book1
ABCDE
10040
20.10.14550
30.20.350
40.40.755
50.250.9560
60.051
Sheet1

in E2:
=VLOOKUP(RAND(),B1:C6,2,1)

Replies
1
Views
110
Replies
1
Views
50
Replies
1
Views
31
Replies
5
Views
48
Replies
3
Views
79