Thread: [Solved] Absolute Column Error
View Single Post
 
Old 12-19-2017, 02:55 PM
ProudLiberal's Avatar
ProudLiberal ProudLiberal is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Jun 2017
Location: suburban Chicago
Posts: 28
ProudLiberal is on a distinguished road
Default

When editing the cell, you can use F4 to toggle through all combinations (AB4, $AB4, AB$4, $AB$4). I don't know if using this tip will solve the problem. Your formula appears correct. I've never seen this type of error. You might try writing the formula in the cell by entering the equal sign with the keyboard, selecting AB4 with the mouse, and using F4 (in this case, 3 times) to set the absolute/relative state you want.

Are you referencing a cell on a separate tab (Master Index)?
Reply With Quote