Hi Folks,

I have a spreadsheet that tracks productivity in my shop. I am far from a spreadsheet master, so I'm sure it is designed all wrong. On a main page, I have the list of all the orders in rows, with the cells tracking what is in the order, who it is for, and at which stage of production it currently is.

I have separate pages for each of the production stages. What I wanted was for the separate pages to automatically pull content form the main page. So I update the main page every day, and the other pages pull content.

I used this countif function =COUNTIF(A2:A110;A113) -- to tell me how many were at a particular stage.

I used some ridiculousness to figure out the line number that the particular production station's production started at, and I was planning to plug that line number into a vlookup formula. My problem is that I have a number as a result sitting in a cell. I want to plug that number into a formula that looks like =IF(L16>0;(VLOOKUP($A$1;Mainpage.$A46:Mainpage.$J$50;2;0));"") Where the formula has "Mainpage.$A46" I am trying to plug in the number that is sitting in my cell, but I don't know how.

The if formula is a function of the number I got from countif, and in successive cells subtracted "1" so that when there weren't any more units for that station of production, it wouldn't post anything to the cells.

I stayed up all night trying to figure this out. If someone can point me in the right direction, I would be much obliged.

Billy Bones