Mar 19 2020 03:30 AM - edited Mar 19 2020 08:10 AM
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
Mar 19 2020 04:00 AM
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.
Mar 19 2020 05:27 AM
Hi @Faraz Shaikh! Thanks for your reply! I attached the sample-file to the initial entry of the conversation!
Kind regards,
Joachim
Mar 19 2020 05:47 AM
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.
Mar 19 2020 08:11 AM
Hi @Faraz Shaikh ! I updated the file to mitigate the error on opening the Excel. Pls. retry! Thanks a lot!
Kind regards,
Joachim
Mar 24 2020 01:13 PM
Hi @Faraz Shaikh,
Did you or your colleagues have a chance to review my problem?
Thanks a lot!
Kind regards,
Joachim
Mar 25 2020 04:40 AM
Mar 25 2020 05:25 AM