Help with VLOOKUP "I Think"

[tommyis3]

Hi Guys.
Ok, here what I want this workbook to do, I have a workbook that is used in manufacturing, which has rolls 1 to 10, once the rolls are complete we need to print a label to say what roll lenths, faults etc are on the roll, so basiclly what i want the workbook to do is, if roll #1 then look at a cell to find the roll length and defects, if the roll is #2 same again down to roll #10, it might be simpler to look at the atatchment.
The prepreg tab needs to take information form the 24" runsheet tab.

[NBVC]

So it's just a matter of positioning? I.e. if Roll 1 take from Cell G18, if roll 2 take from G19, etc...?

If so, then use formulas

in D5: =INDEX('24" Run Sheet'!$G$18:$G$27,$D$3+0)

in D7: =INDEX('24" Run Sheet'!$J$18:$J$27,$D$3+0)

[tommyis3]

Thanks for the quick reply, I will give this a try.

[tommyis3]

NBVC

Thank you, thank you, the formula worked a treat.