Learn Excel – Video 581 – Excel Interview INDIRECT ADDRESS MATCH




About this tutorial:

Video duration: 14:25
If you want to be master in excel ,excel vba or access and access vba – email me at ajayk3802@gmail.com and you can purchase the entire training content and start your learning.

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

4 thoughts on “Learn Excel – Video 581 – Excel Interview INDIRECT ADDRESS MATCH

    somapatil

    (April 15, 2018 - 5:46 pm)

    Hello Ajay Kumar,
    I have 20000 accounts summary report & used duplicate rule. But every date accounts added in my report, there are 3 types of mode Email, Mail & Fax. But sometimes accounts coming duplicates earlier I have taken action on these accounts.
    Kindly help me out for this issue how to sort out duplicate accounts. Is there any formula to use & I can mention these accounts are duplicate.

    Anand G.PILLAY

    (April 15, 2018 - 5:46 pm)

    Hi Guruji.

    I follow your all your videos. Day by day I learning new things. I have started from you 1st video. Sir I need help.

    I need to know about web automation . I am working in immigration process. Wer I have to post the detail of the employee in online. Every til I have login . Data wil be there in excel. I have to copy paste and submit. Instead of that I have to do. automation.

    I just to want run the macro. By which it should login and watever the details will be there it has to copy paste and submit. And go to next row.

    Difficult part is date. In the online have to select but want to just copy paste. And there is drop down for city and country. How I can do this.

    Please help me with this. Thanks in advance.

    Freddy Maertens

    (April 15, 2018 - 5:46 pm)

    sorry, but this is really not the best way to do this lookup in a matrix, you should use the combination of index() and match(). Indirect is a volatile function, to be avoided, in my opinion.

    Enemy killer

    (April 15, 2018 - 5:46 pm)

    Mast nesting done by u

Leave a Reply

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