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_C...
excel
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.

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

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

     

    Kind regards,

    Joachim

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

      Hi @Faraz Shaikh,

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

       

      Thanks a lot!

       

      Kind regards,

      Joachim

      • ExcelExciting's avatar
        ExcelExciting
        MVP
        Mar 25, 2020

        Hi Joachim_Pichler, 

         

        I am still seeing the same Excel File attached 

         

        Regards, Faraz Shaikh.. 

Resources