+ Reply to Thread
Results 1 to 2 of 2

Convert vlookup to INDEX and Match

  1. #1
    Forum Contributor
    Join Date
    09-05-2008
    Location
    UK
    Posts
    103

    Convert vlookup to INDEX and Match

    Hi for some reason my vlookup formula works but doesnt refresh is i change a value in a cell. Sheet is auto calculating. Some other users have had same problem and found index and match to solve it.

    Is it possible to convert this formula to index and match. Never used it before.

    Please Login or Register  to view this content.
    If so could someone post up an example. Thanks

  2. #2
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2016
    Posts
    1,416

    Re: Convert vlookup to INDEX and Match

    You would need to replace the VLookup with somthing like: INDEX(Table4,MATCH([@[COURSESUPERVISION\APPRAISAL]],Table4[COLUMN_HEADER_GOES_HERE],0),2)

    You will need to insert the text value of the actual column header where I've indicated. In other words, replace "COLUMN_HEADER_GOES_HERE " with the header text from labeling the lookup column (Table4, column1)
    Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.

    Please,mark your thread [SOLVED] if you received your answer.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 05-19-2014, 02:01 PM
  2. Replies: 13
    Last Post: 12-13-2012, 11:44 AM
  3. Replies: 2
    Last Post: 03-16-2012, 12:03 PM
  4. convert Index / Match formula to VBA
    By fredo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-24-2011, 10:01 PM
  5. How to convert Index(Match into VBA
    By Alternsti in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-14-2010, 07:39 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1