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

533 thoughts on “INDEX / INDIRECT

  1. TV stand assembly

    I really like your writing style, great info, appreciate it for putting up :D. “He wrapped himself in quotations- as a beggar would enfold himself in the purple of Emperors.” by Rudyard Kipling.

  2. best youtube buy views sites

    I know this if off topic but I’m looking into starting
    my own blog and was curious what all is required to get set up?
    I’m assuming having a blog like yours would cost a pretty penny?
    I’m not very internet smart so I’m not 100% positive. Any suggestions or advice would be greatly appreciated.
    Many thanks


    Please let me know if you’re looking for a article author for your blog.
    You have some really great posts and I believe I would be a good
    asset. If you ever want to take some of the load off,
    I’d love to write some material for your blog in exchange for a
    link back to mine. Please blast me an e-mail if interested.

  4. sofa assembly service

    I haven’t checked in here for some time since I thought it was getting boring, but the last few posts are great quality so I guess I’ll add you back to my everyday bloglist. You deserve it my friend 🙂

  5. verthilertva

    whoah this blog is excellent i love reading your posts. Keep up the good work! You know, a lot of people are looking around for this info, you could aid them greatly.

  6. african businessman

    of course like your web site but you need to check the spelling on quite a few of your posts. Several of them are rife with spelling issues and I in finding it very troublesome to inform the truth nevertheless I will definitely come again again.

  7. HD channels

    I think other web-site proprietors should take this website as an model, very clean and magnificent user friendly style and design, as well as the content. You are an expert in this topic!

  8. Australian Office Furniture Buy

    Together with every little thing that appears to be developing inside this particular subject matter, a significant percentage of points of view happen to be very exciting. Even so, I am sorry, because I do not give credence to your entire theory, all be it stimulating none the less. It looks to everyone that your opinions are actually not totally rationalized and in simple fact you are yourself not totally certain of your argument. In any case I did appreciate looking at it.

  9. hogan outlet

    I definitely wanted to post a quick message so as to express gratitude to you for all the amazing steps you are sharing here. My time-consuming internet investigation has at the end been compensated with awesome tips to exchange with my friends and family. I ‘d repeat that most of us website visitors are really lucky to live in a fabulous website with very many perfect individuals with beneficial suggestions. I feel very much happy to have come across the webpages and look forward to really more cool times reading here. Thanks once more for a lot of things.

  10. autoimmune disease symptoms

    Today, I went to the beach front with my kids. I found a sea shell and gave it to my 4 year old daughter and said “You can hear the ocean if you put this to your ear.” She put the shell to her ear and screamed. There was a hermit crab inside and it pinched her ear. She never wants to go back! LoL I know this is completely off topic but I had to tell someone!

  11. DMV African

    Howdy just wanted to give you a quick heads up. The words in your post seem to be running off the screen in Opera. I’m not sure if this is a format issue or something to do with web browser compatibility but I figured I’d post to let you know. The layout look great though! Hope you get the issue resolved soon. Cheers

  12. best family cruises

    Wonderful blog you have here but I was wanting to know if you knew of any message boards that cover the same topics talked about here? I’d really like to be a part of group where I can get feed-back from other experienced individuals that share the same interest. If you have any suggestions, please let me know. Cheers!

  13. Offline Advertising

    I have not checked in here for a while since I thought it was getting boring, but the last several posts are great quality so I guess I’ll add you back to my everyday bloglist. You deserve it my friend 🙂

  14. Office

    I am very happy to read this. This is the kind of manual that needs to be given and not the random misinformation that’s at the other blogs. Appreciate your sharing this greatest doc.

  15. free itunes gift card

    Does your blog have a contact page? I’m having problems locating it but, I’d like to shoot you
    an email. I’ve got some suggestions for your blog you might be interested in hearing.
    Either way, great blog and I look forward to
    seeing it develop over time.

  16. Bulk CBD Oil

    Thanks for the sensible critique. Me and my neighbor were just preparing to do a little research on this. We got a grab a book from our area library but I think I learned more clear from this post. I am very glad to see such excellent info being shared freely out there.

  17. music

    Thanks for making me to achieve new thoughts about personal computers. I also have the belief that one of the best ways to keep your laptop in perfect condition is by using a hard plastic-type material case, or perhaps shell, that fits over the top of your computer. A majority of these protective gear usually are model precise since they are manufactured to fit perfectly in the natural housing. You can buy all of them directly from the vendor, or via third party sources if they are available for your laptop computer, however not every laptop may have a shell on the market. Again, thanks for your suggestions.

Leave a Reply

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