Results 1 to 2 of 2

Thread: Tracing Formula Frustrations due to complex cell referencing​
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Oct 2019
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Angry Tracing Formula Frustrations due to complex cell referencing​



    Suffering some apparent limitations of Excel.


    Excel cell referencing (i.e. $A$6) can become a major pain when I have to make changes to a complex spreadsheet. Multiple formulas to update etc.

    Tracing the formula is a major pain! I.e. Vlookup(A3, ProductMaster!$A$1:$D$25, 3, false) verses Vlookup(Product Code, Quantity In Stock, Product Master).


    Who shares the frustration? Any solutions!?

  2. #2
    Board Regular jmacleary's Avatar
    Join Date
    Oct 2015
    Location
    at a desk in the UK
    Posts
    672
    Post Thanks / Like
    Mentioned
    15 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Tracing Formula Frustrations due to complex cell referencing​

    Welcome to the forum. I think you answered your own question - use names. Also, I wouldn't call it a 'limitation' rather a feature. One way to possibly help is that if you still use cell references, use find/replace to change the old to the new e.g. $A$6 to $F$22.
    If my answer has helped, please vote using the Thanks or Like buttons on the left.
    John

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •