+ Reply to Thread
Results 1 to 6 of 6

Problem with Index/Match Functions

  1. 02-16-2019, 08:42 PM #1
    Acanthostega
    Acanthostega is offline
    Registered User
    Join Date
    02-16-2019
    Location
    canada
    MS-Off Ver
    2016
    Posts
    3

    Problem with Index/Match Functions

    Hi Everyone!

    I have a list of fictitious SIN's, Student #'s, and First and Last names of students.
    My job is to create a formula so that when I enter a student's SIN number, their corresponding Student#, First/Last name appear in the 3 cells below,


    HOWEVER, I'm not allowed to create different formulas, I can only create one for Student # and use relative cell references to drag and fill the formulas for the First and Last name of the student.

    I have attached my file and I hope that someone can help, thank you very much in advance!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-16-2019, 08:49 PM #2
    jeffreybrown
    jeffreybrown is offline
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Problem with Index/Match Functions

    Hello & Welcome to the Forum,

    In B3 and copied down...

    =INDEX(Personal!$A$2:$C$143,MATCH($B$2,Personal!$D$2:$D$143,0),MATCH($A3,Personal!$A$1:$C$1,0))

    BTW: When you say, "I'm not allowed", does this mean you are doing some type of homework. If this is your file, why would you ever say I'm not allowed to do this or that to get the right answer?
    HTH
    Regards, Jeff
    Reply With QuoteRegister To Reply
  3. 02-16-2019, 09:04 PM #3
    Acanthostega
    Acanthostega is offline
    Registered User
    Join Date
    02-16-2019
    Location
    canada
    MS-Off Ver
    2016
    Posts
    3

    Re: Problem with Index/Match Functions

    Hello,

    Thank you very much Jeff for the quick reply and the help!
    Yeah, I should have been more specific in saying that it was for a homework assignment in which they didn't want us to modify the equations.

    Just one thing, when I use your formula, the first name section brings up "#N/A", so I'm not sure what the problem is there.
    Reply With QuoteRegister To Reply
  4. 02-16-2019, 09:07 PM #4
    jeffreybrown
    jeffreybrown is offline
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Problem with Index/Match Functions

    You must ensure A3:A5 on the Search tab match exactly in word to A1:C1 on the Personal tab. There is a space after Name in cell A5.
    Reply With QuoteRegister To Reply
  5. 02-16-2019, 10:37 PM #5
    Acanthostega
    Acanthostega is offline
    Registered User
    Join Date
    02-16-2019
    Location
    canada
    MS-Off Ver
    2016
    Posts
    3

    Re: Problem with Index/Match Functions

    Hi,

    Thank you very much!
    Attached Files Attached Files
    Last edited by Acanthostega; 02-17-2019 at 12:35 AM.
    Reply With QuoteRegister To Reply
  6. 02-17-2019, 02:11 AM #6
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: Problem with Index/Match Functions

    See post #4 - there is a space after 'First Name' in A5 - remove it.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Problem matching volume data with dates; Index/match functions tried but not working
    By Wintefell89 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 02-08-2018, 03:26 PM
  2. INDEX MATCH Functions
    By paddyanglais91 in forum Excel General
    Replies: 1
    Last Post: 11-02-2016, 02:11 PM
  3. Problem with INDEX/MATCH Functions... Not working as expected.
    By seimeion1208 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-30-2013, 10:26 AM
  4. Problem using the Match, Index, Max functions
    By ExcelNo0b in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 12-17-2012, 03:45 PM
  5. [SOLVED] Index / match functions
    By Helppplease in forum Excel General
    Replies: 7
    Last Post: 05-09-2012, 02:35 AM
  6. Index And Match Functions
    By Ansonicus in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-06-2008, 02:20 PM
  7. [SOLVED] How do I use the Match and Index functions to look up a value tha.
    By Maclanders in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-10-2005, 05:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1