Excel: vlookup - Matrix - Name not being a Name

[Joachim_Pichler]

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

[#2]

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.

[#3]

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

[#4]

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

Kind regards,

Joachim

[#5]

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.

[#6]

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

[#7]

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

Kind regards,

Joachim

[#8]

Hi @Faraz Shaikh,

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

Thanks a lot!

Kind regards,

Joachim

[#9]

Hi @Joachim_Pichler, 

I am still seeing the same Excel File attached 

Regards, Faraz Shaikh.. 

[#10]

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