+ Reply to Thread
Results 1 to 8 of 8

VLOOKUP & MATCH Functions for Two-Dimensional Lookup

  1. #1
    Registered User
    Join Date
    04-05-2015
    Location
    Saihat, Saudi Arabia
    MS-Off Ver
    2013
    Posts
    46

    VLOOKUP & MATCH Functions for Two-Dimensional Lookup



    Hi,
    This Tip is an alternative for Two-Dimensional Lookup by using VLOOKUP & MATCH Functions.

    The VLOOKUP function can only look from left to right, You look a value in one column in a table, and then return a value from a column to the right.

    The MATCH function also has a simple job - look in a column of data and return the row number of a value that you specify.

    We want to use these advantages of VLOOKUP & MATCH functions for Two-Dimensional Lookup as explained in the following example:

    We have merit increases table that based on the annual performance rating of the employee and the position of his/her salary in the salary scale, we are aiming to get the merit increase percentage due to each employee by using the following Formula:

    =VLOOKUP($B10;$A$1:$E$6;MATCH($C10;$A$1:$E$1;0);FALSE)

    Name:  VLOOKUP_MATCH_Function.jpg
Views: 24086
Size:  113.5 KB

    Attachment: VLOOKUP_MATCH_Function.xlsx

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: VLOOKUP & MATCH Functions for Two-Dimensional Lookup

    Much easier with an INDEX function ,that will also work in both directions, and is at least as fast as a VLOOKUP

    (BTW VLOOKUP can also look from right to left...)

  3. #3
    Registered User
    Join Date
    04-05-2015
    Location
    Saihat, Saudi Arabia
    MS-Off Ver
    2013
    Posts
    46

    Re: VLOOKUP & MATCH Functions for Two-Dimensional Lookup

    Hi, Pepe Le Mokko
    Please refer to my Tip: INDEX & MATCH Functions for Two-Dimensional Lookup
    in Execl we should look into all available alternatives to help all users.
    Thanks.
    IMA_Saihat

  4. #4
    Registered User
    Join Date
    09-27-2007
    Posts
    2

    Re: VLOOKUP & MATCH Functions for Two-Dimensional Lookup

    how do you get v-lookup to work from right to left ? Please and thanks.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,395

    Re: VLOOKUP & MATCH Functions for Two-Dimensional Lookup

    Andy - unfortunately your post does not comply with Rule 4 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  6. #6
    Registered User
    Join Date
    01-11-2019
    Location
    CHI
    MS-Off Ver
    2013
    Posts
    22

    Re: VLOOKUP & MATCH Functions for Two-Dimensional Lookup

    Very powerful! Thanks!

  7. #7
    Registered User
    Join Date
    08-01-2019
    Location
    ...
    MS-Off Ver
    16
    Posts
    1

    Re: VLOOKUP & MATCH Functions for Two-Dimensional Lookup

    Hello All,

    I need to generate code for about 10000 students of different place.

    My requirement is to generate place code as well as student code...
    Is there any automatic way in excel to do this...

    Thanks...

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,395

    Re: VLOOKUP & MATCH Functions for Two-Dimensional Lookup

    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

+ 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. INDEX & MATCH Functions for Two-Dimensional Lookup
    By IMA_Saihat in forum Tips and Tutorials
    Replies: 2
    Last Post: 04-20-2015, 04:02 AM
  2. [SOLVED] Using Search and Lookup/Match/Index Functions
    By fl9805 in forum Excel General
    Replies: 14
    Last Post: 08-06-2014, 10:47 AM
  3. [SOLVED] Vlookup and match functions
    By rmachbitz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-22-2013, 05:12 AM
  4. Need help combining an IF statement and lookup, choose, or match functions
    By sixsteps268 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-20-2013, 03:28 PM
  5. Replies: 14
    Last Post: 04-27-2010, 01:20 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