Hello,
I've looked through the forums and am sure that with more experience I could extrapolate the information I need from similar examples, but I lack. Anyway, I have a situation where I want to have a range of probabilities associated with numbers 0-30. I have three ranges (0-10, 11-20, 21-30) and I want to be able to modify these ranges via lookup and calculate the average number to expect given the probabilities. I can do this easily manually, but these ranges could frequently change and I'd like to automate it. I assume it would be some combination of lookup, sumproduct, matching and the likes but I'm not sure how to go about this. I'll attach my situation. Thanks!
Example.xls
Bookmarks