Luke,
Thank you so much. I managed to get it about 15 minutes ago with the help of a coworker. Sorry for taking your time, I got back to the forum as quickly as I could. The formula I settled on is listed below (see SOLUTION:). Basically I used an Index and Match combination to allow me to go...
What I would like to do is choose a date at random, then use VLOOKUP to obtain a value assigned to that date. Once VLOOKUP has established the first value, I then need the next values to follow an assigned sequence. What I'm seeking to do is tie production volumes to a date randomly chosen by me...