Forum Discussion
#REF! Informular when Cut/Paste the reference cells
I am trying to make a score template. The score will be calculated from the x in the scale column that someone else will fill in later. (Right-most column is the calculated score.) The issue is ...
SergeiBaklan Thank you for your support. I am still trying to understand the lookup(2,1/... part.
But to update you the result, I tested your formula. It works really well as long as I do not cut/paste the left-most or right-most cell. If I do, the "ISBLANK(E15:I15)" part will be automatically changed to (F15:I15) or (E15:H15)
I can workaround by inserting a hidden column before and after the scale column to use a a reference point but I don't think that is the right thing to do.
Parwitch , found this post https://www.excelforum.com/excel-formulas-and-functions/1043140-explain-lookup-2-1-a2-a10-d2-b2-b10.html, it explains in more details how LOOKUP(2, 1/.. works