I have recently inherited a new position at work along with a new spreadsheet to record the companies chemical manifest. If you answer yes in column j then all the information is posted on a second worksheet using an offset function. I understand the offset parameters but the spread sheet is using weird cell references that i dont understand . =MATCH($A$1,OFFSET(Manifest!$J$8:$J$162,A2,0),0)+A2-1
the above matches "yes" in a1 then gives me a cell reference but i dont understand this part =OFFSET(Manifest!$A$8,$B10,D$9). The manifest is sheet one. Thanks in advance
the above matches "yes" in a1 then gives me a cell reference but i dont understand this part =OFFSET(Manifest!$A$8,$B10,D$9). The manifest is sheet one. Thanks in advance