Excel: vlookup - Matrix - Name not being a Name

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

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.

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

 

Kind regards,

Joachim

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.

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

 

Kind regards,

Joachim

Hi @Faraz Shaikh,

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

 

Thanks a lot!

 

Kind regards,

Joachim

Hi @Joachim_Pichler

 

I am still seeing the same Excel File attached 

 

Regards, Faraz Shaikh.. 

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.)