Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Vlookup (but the other way round)

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    HI,

    I know how to use Vlookup, but it is not working when my list in column 1 is actually shorter than the list with the lookup values.

    Any advice?

    Silversurfer

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    Try INDEX and MATCH nested, eg


    =INDEX(A1:E10,MATCH("MyValue",C1:C20,0),3)




  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,645
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-03-19 06:20, silversurfer wrote:
    HI,

    I know how to use Vlookup, but it is not working when my list in column 1 is actually shorter than the list with the lookup values.

    Any advice?

    Silversurfer
    Care to provide a small sample that illustrates your problem?

    Aladin

  4. #4
    New Member
    Join Date
    Mar 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    The index and match solution worked!

    Thanks very much

Some videos you may like

User Tag List

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
  •