Row referencing while cross-referencing sheets

Declan2802

This is my current formula in order to input the proper value from my master sheet. I am trying to change it so that I can drag the formula down (similar to Excel) and have the value of 1 update to 2 and so on. From what I have read it seems that the @row function is the answer to this problem but when I use the equation =INDEX({Supply Chain Capex Actual Range}, @row, 3) it is unparseable or=INDEX({Supply Chain Capex Actual Range}, [Supplier Name]@row, 3) is a circular reference.

Paul Newcome

You will need a helper column that has the numbers in it that you can then use a cell reference to in the INDEX function.