I need to be able to supply a product code on one worksheet, then go to
another sheet to do a lookup which will tell me how many cells to the right
of the looked up value to select and bring back to the cell below the code in
the first worksheet. Basically, based on a product code number, I need to
fill in a certain number of cells below it to represent a standard processing
time in days(one cell per day).

Any ideas?