Results 1 to 1 of 1

Thread: Convert All Vlookup formulas to Index-Match in a worksheet

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Member littleiitin's Avatar
    Join Date
    Aug 2011
    Posts
    90
    Rep Power
    14

    Convert All Vlookup formulas to Index-Match in a worksheet

    Hi Everyone,

    I have seen many requests at work to convert Vlookup formulas into Index match.

    Wrote a code which will convert all vlookup formula of a worksheet into Index match formula on a single click.

    The only limitation - this will not convert any Vlookup which is appearing between other formula.

    Thanks
    Rahul
    Attached Files Attached Files
    Last edited by littleiitin; 03-17-2016 at 07:12 PM.

Similar Threads

  1. Convert Excel Formulas That Contain Specific Function In To Value
    By Rajan_Verma in forum Rajan Verma's Corner
    Replies: 5
    Last Post: 09-28-2013, 01:53 AM
  2. Replies: 2
    Last Post: 07-31-2013, 09:59 PM
  3. Replies: 7
    Last Post: 07-26-2013, 06:34 PM
  4. Staffing Scheduling HELP Match/Index
    By mgelston in forum Excel Help
    Replies: 2
    Last Post: 06-20-2013, 01:09 AM
  5. Replies: 4
    Last Post: 04-24-2013, 10:04 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •