User Profile
OMGHelp
Copper Contributor
Joined Sep 19, 2023
User Widgets
Recent Discussions
Re: Formula loses link to named column in another sheet
I am not the primary owner of this file. I recreated the file by copying and pasting the format followed by a copy and paste of the values only. I decided to go back to the beginning, the very beginning and start writing basic formulas with no error coding etc. When I was double checking the format of the columns, it turns out that despite my having set a column, the SAP column, to a number format, Excel would not keep that format. This was an oddity that I have not come across before either. I had to highlight all the entries and do a correction of converting the text to a number. Once that was corrected the column format of number was maintained and the formula worked. Thanks again for your assistance.1.5KViews0likes0CommentsRe: Formula loses link to named column in another sheet
Thank you for taking the time to reply. I tried the 'Fully Qualified Named Range' option, as that was the only solution I had not yet tried and still the same result. Excel actually replaced 'Sheet1' with the name of the file after I pressed enter. Each sheet is behaving as if it cannot see the other one. If I change the column name, it accordingly changes it in the formula and yet the link to the column itself is not there. The only add-in being used (Kofax pdf) I disabled and that did not help either. It is beyond baffling at this point.1.5KViews0likes2CommentsFormula loses link to named column in another sheet
Hi, I have a workbook that consists of two worksheets, Sheet1 & Copy_Paste_List. All the named columns have a scope of the workbook. The named columns show up as you start to write them, while composing the formula, and I select them from the dropdown list. But the only named columns that keep their "link" to the column (i.e. are highlighted in colour) are the columns of the same sheet in which the formula is written. The reference name column goes to black text right after I select it from the dropdown list. I.E. The referenced columns that belong to the Copy_Paste_List sheet, highlight in a formula written in a cell in the Copy_Paste_List sheet but the referenced columns of Sheet1 go black and are not linked to the column. I have never seen this before and am befuddled. =IF(OR(ISERROR(SAP_Fill),ISBLANK(SAP_Fill)),"", IFERROR(INDEX(Mat_Des&CHAR(10)&"(Vndr) "&MFG_VNDR,MATCH(SAP_Fill,SAP,0)),"No such SAP exists")) Microsoft Excel 20161.7KViews0likes4Comments
Recent Blog Articles
No content to show