Forum Discussion

Joachim_Pichler's avatar
Joachim_Pichler
Copper Contributor
Mar 19, 2020

Excel: vlookup - Matrix - Name not being a Name

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

excel

7 Replies

  • ExcelExciting's avatar
    ExcelExciting
    MVP
    Mar 19, 2020

    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.

    • Joachim_Pichler's avatar
      Joachim_Pichler
      Copper Contributor
      Mar 19, 2020

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

       

      Kind regards,

      Joachim

      • ExcelExciting's avatar
        ExcelExciting
        MVP
        Mar 19, 2020

        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.

Resources