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

      • 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

Resources