Probability in excel using lookup?

[chasey]

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

Daily sales	  40     45	    50	55    60

Probability	  10%   20%       40%   25%    5%

 

[PA HS Teacher]

Book1
	A	B	C	D	E
1	0	0	40
2	0.1	0.1	45		50
3	0.2	0.3	50
4	0.4	0.7	55
5	0.25	0.95	60
6	0.05	1
Sheet1

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