vlookup on date and then add

[stephme55]

In column 1, I have customers 1,2,3,4,5,6,7.....etc. There is an associated date in column 2.
In column 3 (customer code) and 4, each of these customers has multiple invoices. So Customer 1, might have 4 invoices. So in column 2 it would 1,1,1,1 and column 3 would be 1,2,3,4 for invoices.

I did a vlookup for date, but for each successive date after the first (RELATED to each unique customer) I would like random interval increases. How can I do this? Spreadsheet attached.

[sh4d0w1ink]

I'm guessing you have a column with all of your customers (several entries of the same customer) with a column of dates next to it, but there's only one date present for each customer leaving blank spaces next to the duplicate customer numbers for dates. If that's the case, highlight the date column, go to Find & Select -> Go to Special -> Blanks, and enter the following:

Please Login or Register  to view this content.

Where A1 is the first date entry that you have (first date, customer #1). This will essentially keep adding a random number between 1 and 100 (you can change these numbers if you like) to the above date until it gets to another manually entered date, at which point the cycle starts over. I think this gets at your question?

[eibi]

I can replicate the desired results you requested in the sample workbook using the following formula, pasted in Cell G6 and dragged down to fill.

=IF(COUNTIF($E$6:E6,E6)>1,F5+RANDBETWEEN(1,60),VLOOKUP(E6,$A$6:$B$9,2)) -- where the random interval is between 1 and 60

Beware! Using the RANDBETWEEN formula to create the "random" intervals (as you requested) creates volatile formulas that will change every time the workbook recalculates.