Forum Discussion

Alex159's avatar
Alex159
Copper Contributor
Oct 15, 2019

Formula Format Settings

Hi All,    I have encountered and issue with the settings of my formulas I use for work around data manipulation.   When using VLOOKUPS and COUNTIFS the table or range in which the formula looks ...
excel
PascalKTeam's avatar
PascalKTeam
Iron Contributor
Oct 15, 2019
Looks like you should use an absolute reference. Let's assume that this formula Sheet3!I2:I133 should always start at I2, even if you copy it a down a couple of rows you have to make row 2 an absolute reference by adding $ to the formula like this: Sheet3!I$2:I133
  • Alex159's avatar
    Alex159
    Copper Contributor
    Oct 16, 2019

    Awesome thanks for the advice, any reason why this could be happening and not to other members of my team?

    • PascalKTeam's avatar
      PascalKTeam
      Iron Contributor
      Oct 16, 2019
      Since this is standard excel behaviour it should be the same for all users

Resources