In this video, you talk about fixing row references and in the earlier video, you talked about both row and column references used $ symbol. I did not get what does it mean. And how an excel table can change its position. And if it changes the position of how reference is able to trace it. https://learn.365datascience.com/courses/introduction-to-microsoft-excel/index-match-and-their-combination-the-perfect-substitute-for-vlookup

Hello,Please go ahead with the ‘Build a P&L from scratch’ case study we have provided.You will gain clarity on how to use cell references.Best,Ned

Follow this topic

Last answered:

16 Apr 2020

Posted on:

07 Apr 2020

Fixing a reference in Excel

1 answers ( 0 marked as helpful)

Instructor

Posted on:

16 Apr 2020