I am using the INDIRECT function to get data from a file and would like to use the INDEX,MATCH function instead. This would mean the i can access the data witout opening the file. As i have many files that i get data from i get the filename suffix from a cell. this works for INDIRECT but i can get it to work for INDEX.

=VLOOKUP(B7,INDIRECT(“‘C:UsersGW193DesktopSyd[ABC data “&E8&”.xlsx]Data’!I:M”),3,0))

The source file name is ABC data 190821A021.xlsx

=INDEX(‘c:UsersGW193DesktopSyd[ABC data “&E8&”.xlsx]Data’!$I:$O,MATCH(D8,’C:UsersGW193DesktopSyd[ABC data “&E8&”.xlsx]Data’!$I:$I,0),3)

If i use the INDEX/MATCH with the exact file name it works but when i use the cell reference to get the file name i can’t get it to work


By: Sydney

935 thoughts on “INDEX / INDIRECT

  1. dotafrog

    Wonderful blog! Do you have any suggestions for aspiring writers? I’m planning to start my own site soon but I’m a little lost on everything. Would you advise starting with a free platform like WordPress or go for a paid option? There are so many options out there that I’m completely confused .. Any ideas? Thanks a lot!


    Great post. I was checking continuously this blog and I’m impressed! Very useful information specially the last part 🙂 I care for such info much. I was looking for this certain info for a very long time. Thank you and best of luck.

  3. DCA Car service

    Youre so cool! I dont suppose Ive read anything like this before. So nice to search out any person with some unique ideas on this subject. realy thank you for starting this up. this website is one thing that’s wanted on the web, somebody with slightly originality. useful job for bringing something new to the internet!

  4. схема русского музея

    Undeniably believe that which you stated. Your favorite justification appeared to be on the web the simplest thing to be aware of. I say to you, I definitely get irked while people think about worries that they plainly do not know about. You managed to hit the nail upon the top and also defined out the whole thing without having side effect , people could take a signal. Will probably be back to get more. Thanks| а

  5. yeezy boost 350

    I not to mention my pals were found to be taking note of the nice things found on the website then quickly got an awful feeling I had not thanked the site owner for those secrets. The young men had been for that reason excited to see them and now have in fact been making the most of these things. Appreciation for getting quite accommodating and for making a decision on this form of fine things most people are really wanting to be informed on. My personal honest regret for not expressing appreciation to you sooner.

  6. гдз по рабочей тетради окружающий мир плешаков 4 класс часть

    Unquestionably imagine that that you said. Your favourite reason appeared to be at the net the simplest factor to remember of. I say to you, I definitely get irked at the same time as other folks consider concerns that they just don’t know about. You controlled to hit the nail upon the top and also outlined out the entire thing with no need side-effects , other folks can take a signal. Will likely be again to get more. Thanks| а

  7. DC Movers

    I don’t even know how I ended up here, but I thought this post was good. I don’t know who you are but definitely you’re going to a famous blogger if you aren’t already 😉 Cheers!

  8. online gokkasten steptimer

    spelen met gokkasten , gokje casino – vintage speelautomaat : casino geld verdienen online .

Leave a Reply

Your email address will not be published. Required fields are marked *