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. 03-17-2016, 06:50 PM #1
    littleiitin
    littleiitin is offline
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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. Vertical and Horizontal Lookup Using Match And Index Function
    By sarah in forum Excel Help
    Replies: 2
    Last Post: 07-31-2013, 09:59 PM
  3. Match And Index Formula To Lookup Data From Table
    By srizki in forum Excel Help
    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. Lookup On Multiple Columns And Return Result Using Match Index
    By nikhil83 in forum Excel Help
    Replies: 4
    Last Post: 04-24-2013, 10:04 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Forum Rules