In Excel, I have a column of rows. In the rows I enter information about steel building products. To the right of each row I have a long row of formulas. When the information from the column on the left meets the tests for a cell on the right it activates that cell which draws information from a pool of cells on the same page. All of this works fine on my first trial row, BUT!!!, when I copy and special paste the formula to the next row down, because I have several rows that need to do the same task, the cell will draw information from the exact same pool of information cells but cascade down, row for row, therefor retrieving wrong information.
I hope that makes sense. I would be glad to upload to a fileshare sight but would have to learn how to do it.
Howard's Metal Sales
This was my original formula =IF(AND(E13=16,H13=8),P6,0)
This is my revised formula =IF(AND(E13=16,H13=8),$P6,0)
Is this correct? Nope, didn't work.
I figured it out!! It has to be =IF(AND(E13=16,H13=8),$P$6,0)
GREAT! Thank You!
No! I figured it out with your help!
Just making sure that everything is complete and you got paid for assisting me.