Excel: vlookup - Matrix - Name not being a Name

%3CLINGO-SUB%20id%3D%22lingo-sub-1237809%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3A%20vlookup%20-%20Matrix%20-%20Name%20not%20being%20a%20Name%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1237809%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F586719%22%20target%3D%22_blank%22%3E%40Joachim_Pichler%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20attached%20the%20sample%20file%20to%20assist%20you%20on%20your%20query.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22lia-message-body%20lia-component-message-view-widget-body%20lia-component-body-signature-highlight-escalation%20lia-component-message-view-widget-body-signature-highlight-escalation%22%3E%3CDIV%20class%3D%22lia-message-body-content%22%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%20Answer%3C%2FSPAN%3E.%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1238066%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3A%20vlookup%20-%20Matrix%20-%20Name%20not%20being%20a%20Name%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1238066%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156456%22%20target%3D%22_blank%22%3E%40Faraz%20Shaikh%3C%2FA%3E!%20Thanks%20for%20your%20reply!%20I%20attached%20the%20sample-file%20to%20the%20initial%20entry%20of%20the%20conversation!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%2C%3C%2FP%3E%3CP%3EJoachim%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1238108%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3A%20vlookup%20-%20Matrix%20-%20Name%20not%20being%20a%20Name%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1238108%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F586719%22%20target%3D%22_blank%22%3E%40Joachim_Pichler%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eattached%20file%20have%20external%20source%20which%20is%20not%20updating%20%26amp%3B%20helping%2C%20could%20you%20please%20add%20that%20source%20in%20the%20workbook%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22lia-message-body%20lia-component-message-view-widget-body%20lia-component-body-signature-highlight-escalation%20lia-component-message-view-widget-body-signature-highlight-escalation%22%3E%3CDIV%20class%3D%22lia-message-body-content%22%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%20Answer%3C%2FSPAN%3E.%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1237719%22%20slang%3D%22en-US%22%3EExcel%3A%20vlookup%20-%20Matrix%20-%20Name%20not%20being%20a%20Name%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1237719%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20the%20following%20formula%3A%3C%2FP%3E%3CP%3EVLOOKUP(E36%2C%3CSTRONG%3EProgram_Comments%3C%2FSTRONG%3E%2C78%2CFALSE)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20term%20%22Program_Comments%22%20seems%20to%20refer%20to%202%20adjacent%20cells%20in%20the%20same%20row%2C%20if%20I%20click%20on%20it.%3C%2FP%3E%3CP%3EBut%20%22Program_Comments%22%20is%20NOT%20a%20name%20(%3D%20not%20contained%20in%20list%20of%20Name%20Manager).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20can%20it%20be%20then%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20attached%20file.%20The%20whole%20formula%20is%20in%20cell%20H8%20(tab%20%22Outlook%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%2C%3C%2FP%3E%3CP%3EJoachim%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1237719%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1238527%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3A%20vlookup%20-%20Matrix%20-%20Name%20not%20being%20a%20Name%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1238527%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156456%22%20target%3D%22_blank%22%3E%40Faraz%20Shaikh%3C%2FA%3E%26nbsp%3B!%20I%20updated%20the%20file%20to%20mitigate%20the%20error%20on%20opening%20the%20Excel.%20Pls.%20retry!%20Thanks%20a%20lot!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%2C%3C%2FP%3E%3CP%3EJoachim%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1250489%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3A%20vlookup%20-%20Matrix%20-%20Name%20not%20being%20a%20Name%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1250489%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156456%22%20target%3D%22_blank%22%3E%40Faraz%20Shaikh%3C%2FA%3E%2C%3C%2FP%3E%3CP%3EDid%20you%20or%20your%20colleagues%20have%20a%20chance%20to%20review%20my%20problem%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20a%20lot!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%2C%3C%2FP%3E%3CP%3EJoachim%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1251924%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3A%20vlookup%20-%20Matrix%20-%20Name%20not%20being%20a%20Name%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1251924%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F586719%22%20target%3D%22_blank%22%3E%40Joachim_Pichler%3C%2FA%3E%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20still%20seeing%20the%20same%20Excel%20File%20attached%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%20Faraz%20Shaikh..%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1252035%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3A%20vlookup%20-%20Matrix%20-%20Name%20not%20being%20a%20Name%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1252035%22%20slang%3D%22en-US%22%3EIt%20has%20the%20same%20name%2C%20but%20I%20replaced%20it.%20You%20can%20now%20open%20it%20without%20an%20error%20message.%20(for%20the%20analysis%20of%20the%20formula%20links%20are%20not%20needed%20anyway.)%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi all,

 

I have the following formula:

VLOOKUP(E36,Program_Comments,78,FALSE)

 

The term "Program_Comments" seems to refer to 2 adjacent cells in the same row, if I click on it.

But "Program_Comments" is NOT a name (= not contained in list of Name Manager).

 

What can it be then?

 

See attached file. The whole formula is in cell H8 (tab "Outlook")

 

Kind regards,

Joachim

7 Replies
Highlighted

Hi @Joachim_Pichler 

 

Please attached the sample file to assist you on your query. 

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer.

Highlighted

Hi @Faraz Shaikh! Thanks for your reply! I attached the sample-file to the initial entry of the conversation!

 

Kind regards,

Joachim

Highlighted

hi @Joachim_Pichler,

 

attached file have external source which is not updating & helping, could you please add that source in the workbook

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer.

Highlighted

Hi @Faraz Shaikh ! I updated the file to mitigate the error on opening the Excel. Pls. retry! Thanks a lot!

 

Kind regards,

Joachim

Highlighted

Hi @Faraz Shaikh,

Did you or your colleagues have a chance to review my problem?

 

Thanks a lot!

 

Kind regards,

Joachim

Highlighted

Hi @Joachim_Pichler

 

I am still seeing the same Excel File attached 

 

Regards, Faraz Shaikh.. 

Highlighted
It has the same name, but I replaced it. You can now open it without an error message. (for the analysis of the formula links are not needed anyway.)