A question about the formula result and name

%3CLINGO-SUB%20id%3D%22lingo-sub-1598316%22%20slang%3D%22zh-CN%22%3EA%20question%20question%20the%20formula%20result%20and%20name.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1598316%22%20slang%3D%22zh-CN%22%3E%3CDIV%20class%3D%22trans-left%22%3E%3CDIV%20class%3D%22trans-input-wrap%22%3E%3CDIV%20class%3D%22input-wrap%22%3E%3CDIV%20class%3D%22textarea-wrap%20without-textarea-bg%22%3E%3CDIV%20class%3D%22textarea-bg-text%20small-font%22%3E%3CSPAN%20class%3D%22high-light-bg%22%3EHello%2C%20I%20wrote%20a%20formula%3A%20INDIRECT%20(ADDRESS(ROW))%2C%20COLUMN(1)%2C)%2C%20to%20get%20the%20value%20of%20the%20the%20cell%20on%20the%20left%20of%20the%20left%20of%20the%20current%20cell.%20This%20value%20is%20a%20name%20already%20existing%20in%20the%20name%20manager.%20Why%20is%20this%20value%20only%20the%20name%2C%20but%20not%20the%20tha%20it%20ath%20a%20post%20value%20of%20the%20name%20in%20the%20name%20%3C%2FSPAN%3E%20manager%3F%20%3CSPAN%20class%3D%22%22%3EIs%20there%20any%20time%20way%20to%20get%20the%20right%20value%3F%3C%2FSPAN%3E%20.%20%3CSPAN%20class%3D%22%22%3EPlease%20try%20not%20to%20use%20VBA%2C%20thank%20you.%3C%2FSPAN%3E%20.%20.%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1598316%22%20slang%3D%22zh-CN%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Regular Visitor
Hello, I wrote a formula: INDIRECT(ADDRESS(ROW(), COLUMN()-1)), to obtain the value of the cell on the left of the current cell. This value is a name already existing in the name manager. Why is this value only the name, but not the corresponding value of the name in the name Manager? Is there any way to get the corresponding value? Please try not to use VBA, thank you.
0 Replies