+ Reply to Thread
Results 1 to 3 of 3

Vlookup or Match index for retrieving multiple data for same id

  1. #1
    Registered User
    Join Date
    12-21-2013
    Location
    chennai
    MS-Off Ver
    Excel 2013
    Posts
    19

    Vlookup or Match index for retrieving multiple data for same id

    Dear All,

    Please any help me to retrive the data from the master sheet to result sheet for the table having multiple card number for the same ID.

    Attached file here with
    Attached Files Attached Files

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Vlookup or Match index for retrieving multiple data for same id

    S3
    Please Login or Register  to view this content.
    Try above array formula, copy and paste towards down

    ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Registered User
    Join Date
    12-21-2013
    Location
    chennai
    MS-Off Ver
    Excel 2013
    Posts
    19

    Re: Vlookup or Match index for retrieving multiple data for same id

    Quote Originally Posted by samba_ravi View Post
    S3
    Please Login or Register  to view this content.
    Try above array formula, copy and paste towards down

    ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
    DEar Samb

    Thank u for the help at the earliest.

    Good job

+ 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] Retrieving data - MATCH INDEX or multiple IF statements?
    By REV18 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-27-2018, 04:32 AM
  2. Multiple data by using Vlookup + Index and Match
    By EthanK in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-16-2017, 08:49 AM
  3. [SOLVED] Retrieving multiple results with INDEX MATCH?
    By alinahaylie in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-12-2017, 11:09 AM
  4. [SOLVED] Returning Multiple Rows of Data (VLOOKUP/INDEX MATCH)
    By aglasier in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-30-2017, 12:49 PM
  5. [SOLVED] Vlookup/Index/Match on multiple sheets data
    By yabi0823 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-30-2014, 03:47 PM
  6. [SOLVED] MATCH-INDEX function for retrieving specific year data in a table...
    By portsample in forum Excel General
    Replies: 4
    Last Post: 12-16-2014, 04:48 PM
  7. Index/Match or Vlookup for retrieving data from rows?
    By awcwa in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-05-2013, 01:52 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