+ Reply to Thread
Results 1 to 1 of 1

Create relationship between 2 spreadsheets

  1. #1
    Registered User
    Join Date
    04-19-2010
    Location
    Minneapolis
    MS-Off Ver
    Excel 2008 for Mac
    Posts
    19

    Question Create relationship between 2 spreadsheets

    I have a SS named Students, with Student ID#, {LName, FNam}, Grade. The column assignments are: Column A = Student ID#, Column B ={LName, FNam}, Column C =Grade
    I want to use this information to populate the second spreadsheet which looks like this:

    The second SS is names Skipped and has the same three columns: Student ID#, {LName, FNam}, Grade. The column assignments are: Column A = Student ID#, Column B ={LName, FNam}, Column C =Grade


    I have use the following formula in the ID# column to lookup the information in the Student SS:

    IF(ISNUMBER(MATCH($B2,Students!C1,0)),INDEX(Students!C2,MATCH($B2,Students!C1,0)),"not found")

    However, when I enter a Student ID#, it does not do the lookup and input the name and grade on the Skipped SS.
    Last edited by JBeaucaire; 05-08-2013 at 11:09 AM. Reason: Moved to new thread, as per forum rules.

+ 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