Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Reverse VLOOKUP....Is it possible??
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jul 2002
    Posts
    614
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Post Reverse VLOOKUP....Is it possible??

    Hi,

    I would like to find a data which is in the left side column of the lookup data.

    EXAMPLE

    Col A Col B Col C

    XYZ 123 12.3%

    ABC 345 15.2%

    EFG 105 10.3%

    I would like to pick up the data in col A for the maximum value of Col C.

    Here in this example it is "ABC" as 15.2% is the maximum value.

    Col C value keeps changing on every update.



    TIA

    GNAGA
    Regards
    GNaga

  2. #2
    Board Regular James006's Avatar
    Join Date
    Apr 2009
    Posts
    3,587
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Reverse VLOOKUP....Is it possible??

    Hi,

    You could test following

    =INDEX($A$1:$A$4,MATCH(MAX($C$2:$C$4),$C$1:$C$4,0))

    Hope this will help

  3. #3
    Board Regular
    Join Date
    Jul 2002
    Posts
    614
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Reverse VLOOKUP....Is it possible??

    Thanks fro your help.

    I am getting #REF error when use this in my real data table.

    I am skipping the header row. Is this a problem?
    Regards
    GNaga

  4. #4
    Board Regular James006's Avatar
    Join Date
    Apr 2009
    Posts
    3,587
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Reverse VLOOKUP....Is it possible??

    You could try

    =INDEX($A$2:$A$4,MATCH(MAX($C$2:$C$4),$C$2:$C$4,0))

  5. #5
    Board Regular
    Join Date
    Jul 2002
    Posts
    614
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Reverse VLOOKUP....Is it possible??

    Yes this was I tried by skipping the header row. Still I am getting the #REF error.

    My data range is B4:N153

    The column N having a number stored in % format. I would like to pick the data in Column B for the maximum % value in Column N.

    within this range I hid few rows and columns - Is this making any problem?
    Regards
    GNaga

  6. #6
    Board Regular James006's Avatar
    Join Date
    Apr 2009
    Posts
    3,587
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Reverse VLOOKUP....Is it possible??

    Can you post the formula you are using ...

    Why are you pointing to " Reverse VLOOKUP " as the solution to your question ... ???
    Last edited by James006; Oct 19th, 2019 at 10:23 AM.

  7. #7
    Board Regular
    Join Date
    Jul 2002
    Posts
    614
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Reverse VLOOKUP....Is it possible??

    =INDEX($B$4:$N$153,MATCH(MAX($N$4:$N$153),$N$4:$N$153,0))

    I posted it as Reverse Lookup, because my data (Col B) which is to be picked is in the left side of the reference data (Col N).
    Regards
    GNaga

  8. #8
    Board Regular
    Join Date
    Jul 2002
    Posts
    614
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Reverse VLOOKUP....Is it possible??

    Sorry I corrected my Formula and working fine.
    =INDEX($B$4:$B$153,MATCH(MAX($N$4:$N$153),$N$4:$N$153,0))
    Regards
    GNaga

  9. #9
    Board Regular James006's Avatar
    Join Date
    Apr 2009
    Posts
    3,587
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Reverse VLOOKUP....Is it possible??

    Glad you could fix your problem ...

  10. #10
    Board Regular
    Join Date
    Jul 2002
    Posts
    614
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Reverse VLOOKUP....Is it possible??

    Thanks James006..It is working correctly.
    Regards
    GNaga

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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