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?

Would you mind supplying a simple example? I'm not clear what you mean when
you say "to fill in a certain number of cells below it" (what are you filling
into those cells?).

Regards,
Bill



"Chad@KSA" wrote:

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?

Thanks for replying Bill. I am trying to create a 24-hr calendare for
time-tracking on equipment that produces chemicals. Each chemical has a
product code number. I want to enter the product code number on one
worksheet, then perform a lookup on a different sheet that looks up the
product code, then the column next to it to get the number of standard hours
it takes to produce the material, then based on that number take the same
number of cells to the right back to the first worksheet but start the
placement directly below cell that has the product code.

worksheet#1
Product code
X

worksheet#2
Product Code Standard hours Standard Plot
123 12 abcxxxxxxxxx(each character is a
cell)
124 16 defxxxxxxxxxxxxx
125 14 ghixxxxxxxxxxx

worksheet#1
Product code
124 125 123
defxxxxxxxxxxxxx ghixxxxxxxxxxxx abcxxxxxxxxxx

Am I still confusing? Thanks

"Bill Pfister" wrote:

Would you mind supplying a simple example? I'm not clear what you mean when
you say "to fill in a certain number of cells below it" (what are you filling
into those cells?).

Regards,
Bill



"Chad@KSA" wrote:

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?

Take a look at the linked example to see if it does what you need.
http://wcpii.com/Documents/Product%20Lookup.xls

It assumes that you have a maximum limit on the possible number of cells you
woutld return (I used 10 columns in the example).



"Chad@KSA" wrote:

Thanks for replying Bill. I am trying to create a 24-hr calendare for
time-tracking on equipment that produces chemicals. Each chemical has a
product code number. I want to enter the product code number on one
worksheet, then perform a lookup on a different sheet that looks up the
product code, then the column next to it to get the number of standard hours
it takes to produce the material, then based on that number take the same
number of cells to the right back to the first worksheet but start the
placement directly below cell that has the product code.

worksheet#1
Product code
X

worksheet#2
Product Code Standard hours Standard Plot
123 12 abcxxxxxxxxx(each character is a
cell)
124 16 defxxxxxxxxxxxxx
125 14 ghixxxxxxxxxxx

worksheet#1
Product code
124 125 123
defxxxxxxxxxxxxx ghixxxxxxxxxxxx abcxxxxxxxxxx

Am I still confusing? Thanks

"Bill Pfister" wrote:

Would you mind supplying a simple example? I'm not clear what you mean when
you say "to fill in a certain number of cells below it" (what are you filling
into those cells?).

Regards,
Bill



"Chad@KSA" wrote:

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?