+ Reply to Thread
Results 1 to 2 of 2

index/match/vlookup help!

  1. #1
    Registered User
    Join Date
    07-15-2015
    Location
    manchester
    MS-Off Ver
    2013
    Posts
    1

    index/match/vlookup help!

    Hiya,

    I am trying to build a spreadsheet that will return some specific values across 2 worksheets.

    In worksheet one i have;

    sales partner name number deals application id
    amy 15 1089308

    and in worksheet 2 i have;

    n/a n/a application id
    n/a n/a 1089505

    both worksheets have around 1000 rows of data (not in order!) in and i cannot manipulate the columns to use a standard vlookup.

    What i would like to do is;
    • in worksheet 2 I want to look up the application id on that line (i.e C1, C2 etc) on worksheet 1 (could be c600/c58/c7 etc) and return the name of the sales partner that did it.

    i have tried various match/index/vlookup formulas but i cannot get it to work!

    Thanks,

  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: index/match/vlookup help!

    Like =index(sheet1!a2:a100,match(sheet2!C2,sheet1!c2:C100,0)) ?

+ 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. Replies: 1
    Last Post: 06-18-2015, 08:45 AM
  2. Replies: 2
    Last Post: 12-18-2014, 09:52 AM
  3. [SOLVED] Vlookup/index/match to return all values that match
    By Asil01 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-09-2014, 12:49 PM
  4. Replies: 3
    Last Post: 05-19-2014, 02:01 PM
  5. Replies: 4
    Last Post: 01-13-2014, 04:16 AM
  6. Replies: 13
    Last Post: 12-13-2012, 11:44 AM
  7. Replies: 2
    Last Post: 03-16-2012, 12:03 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1