+ Reply to Thread
Results 1 to 2 of 2

Combination VLookUp

  1. #1
    Registered User
    Join Date
    06-09-2011
    Location
    Boston, MA
    MS-Off Ver
    Excel 2011
    Posts
    12

    Combination VLookUp

    Trying to figure out how to do a VLOOKUP function or combination of functions to identify a value on a table using two paramaters.

    Here is a string of data:

    Ven ID Site ID Ins Ref Site ID Ins Ref Site ID Insurance Ref

    1221 8393 21 7768 12 9399 29
    2113 8493 34 6364 87 3349 54
    4395 6362 88 8372 41 8393 28
    3993 3382 62 9549 63 7629 39
    2214 9399 82 3382 91 8492 19
    9849 9549 76 1121 24 4382 20

    So want to be able to input values:

    3993 and 3383 and have it return 62 (value in the next column after 6364).

    Note - 3383 may exist in other rows, but the value after will be different and the location or column will be different.

    Thank you for the help!

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,375

    Re: Combination VLookUp

    Assuming your data starts in column A and the first row is used for labels:

    =INDEX(C1:C7,MATCH(3993&3382,INDEX(A1:A7&B1:B7,0),0))

    cheers, teylyn

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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