+ Reply to Thread
Results 1 to 4 of 4

VLOOKUP/INDEX/MATCH to return all values that match

  1. #1
    Registered User
    Join Date
    02-04-2014
    Location
    nj
    MS-Off Ver
    Excel 2010
    Posts
    2

    VLOOKUP/INDEX/MATCH to return all values that match

    Hi,
    I have two sheets of data , sheet A and Sheet B.

    Sheet B contains a column called "Name" and for each name, and for each name there are corresponding numbers. In sheet A, I have a "list of interest" in column A. What i want to do look through the data in sheetB to find a match from the list of interest and return the corresponding letters, located in column A.

    I have filled out the first two rows of results that should be returned as an example.


    One idea i had was to put a vlookup formula in each column result 1 to result 6 so i can catch all 6 "Serves" columns from column B, but there may be duplicates in the serve columns and vlookup only reports the first match.


    Thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,376

    Re: VLOOKUP/INDEX/MATCH to return all values that match

    Hi lijia00,
    try it
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    02-04-2014
    Location
    nj
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: VLOOKUP/INDEX/MATCH to return all values that match

    Thank you that worked! I want to know, what does the offset in .end(xltoleft)(1,2) do? It looks like its offsetting 1 row and 2 columns?

  4. #4
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,376

    Re: VLOOKUP/INDEX/MATCH to return all values that match

    .End(xlToLeft)(1, 2) is the same as .End(xlToLeft).Offset(0, 1)

+ 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. [SOLVED] Index and Match to return ALL matching values
    By garciapliz in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-07-2015, 05:41 AM
  2. [SOLVED] Formula (VLOOKUP vs INDEX & MATCH) to return multiple values in the same column
    By wfidler in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-06-2012, 07:04 PM
  3. [SOLVED] How to use Index Match to return multiple values
    By pingpoeng in forum Excel General
    Replies: 2
    Last Post: 04-09-2012, 09:58 PM
  4. Replies: 2
    Last Post: 01-12-2012, 07:02 AM
  5. Index Match or Vlookup to return values?
    By Chesney95 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-30-2007, 11:05 AM

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