+ Reply to Thread
Results 1 to 4 of 4

Reverse Vlookup

  1. 06-22-2015, 03:02 AM #1
    Ankit_Kumar
    Ankit_Kumar is offline
    Registered User
    Join Date
    04-20-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    77

    Reverse Vlookup

    Hello Everyone,

    Is there any to use the vlookup for reverse, Vlookup pick the data from the left most columns and If I want to pick data from right side so can I do this through Vlookup function.

    Thanks for any help
    Reply With QuoteRegister To Reply
  2. 06-22-2015, 03:17 AM #2
    NeedForExcel
    NeedForExcel is offline
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Reverse Vlookup

    There are multiple ways to do it..

    People generally prefer Index & Match..

    I also have a video using Vlookup & Choose

    http://www.needforexcel.com/#!videos/c10fk

    Check out Lesson 21 on the link
    Cheers!
    Deep Dave
    Reply With QuoteRegister To Reply
  3. 06-22-2015, 03:17 AM #3
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Reverse Vlookup

    Use Index & Match combination which will work in both scenarios.

    http://www.randomwok.com/excel/how-to-use-index-match/

    http://www.contextures.com/xlFunctions03.html

    https://www.ablebits.com/office-addi...ction-vlookup/


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved

    If the suggestion helps you, then Click *below to Add Reputation
    Reply With QuoteRegister To Reply
  4. 06-22-2015, 03:17 AM #4
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Reverse Vlookup

    Use INDEX/MATCH instead. Faster and more possibilities
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to do a Reverse VLOOKUP
    By daveb86 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-21-2015, 11:13 PM
  2. Reverse VLOOKUP?
    By artistapart in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-20-2013, 03:12 PM
  3. reverse vlookup how
    By arctushar in forum Excel General
    Replies: 5
    Last Post: 02-08-2012, 08:57 AM
  4. vlookup in reverse
    By Newbie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-30-2006, 08:25 AM
  5. reverse vlookup
    By John in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-04-2006, 05:15 PM

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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1