+ Reply to Thread
Results 1 to 4 of 4

Multi or two way vlook up and index match tutorial

Hybrid View

  1. #1
    Registered User
    Join Date
    10-22-2013
    Location
    bangladesh
    MS-Off Ver
    Excel 2003
    Posts
    1

    Multi or two way vlook up and index match tutorial

    Hello,

    I just can know one way vlook up, example: one look up value, one criteria. Is there any web or source where i can learn the below look up or index match function ?

    1) one look up multiple array
    2) Multiple look up one array
    3) Multiple look up multiple array.

    As i am stil amateur in excel, the easiest source is preferable.

    can you help guys ?

    SIEMON

  2. #2
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Multi or two way vlook up and index match tutorial

    look here:
    http://www.get-digital-help.com/
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

  3. #3
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: Multi or two way vlook up and index match tutorial

    SIEMON7,

    See if the following link will help you.

    INDEX MATCH - Excel Index Function and Excel Match Function
    http://www.contextures.com/xlFunctions03.html
    Have a great day,
    Stan

    Windows 10, Excel 2007, on a PC.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

  4. #4
    Forum Contributor ryan4646's Avatar
    Join Date
    06-10-2013
    Location
    Australia
    MS-Off Ver
    Excel 2003, 2007
    Posts
    134

    Re: Multi or two way vlook up and index match tutorial

    I found youtube has lesson based video.you can check there also.
    thanks,

    Ryan

+ 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: 6
    Last Post: 04-30-2014, 02:42 AM
  2. Excel 2007 : Index, Match, or multi Vlookup
    By tlafferty in forum Excel General
    Replies: 3
    Last Post: 04-18-2012, 03:40 AM
  3. need help in sum up multi criterias (index & match)
    By aroundyou in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-17-2006, 08:25 PM
  4. vlook/match/index
    By nowfal in forum Excel General
    Replies: 12
    Last Post: 08-30-2005, 04:05 PM
  5. Vlook up or index match
    By jerry in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-24-2005, 01:06 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