+ Reply to Thread
Results 1 to 5 of 5

Formula to pull data from one sheet and column for another sheet.

  1. #1
    Forum Contributor
    Join Date
    05-29-2012
    Location
    Walnut, Ca
    MS-Off Ver
    Excel 2010
    Posts
    180

    Formula to pull data from one sheet and column for another sheet.

    Hello,

    I have a spreadsheet and I am pretty sure that there is a way to do what I want but I am not sure how difficult. Sheet "student worker pay" has multiple formulas that work off of the data in column b. I was wondering if there is a way to have column B automatically fill in based on sheet "student worker list" column B?

    The problem will be, sometimes, there will be entries of the same student on "student worker list" but with different dates listed in E and F. They will have a different ID # though. Is it possible for "student worker Pay" to match say cell A13 to column A in "student worker List" to find the row then use g13 on "student worker pay" to make sure it is equal to or falls in between column E and F on "student worker list"?

    =IF(AND(A13='Student Worker List'!$A$2:$A$1500,G13>='Student Worker List'!E2:E1500,G13<='Student Worker List'!F2:F1500),MATCH(B2,'Student Worker List'!$B$2:$B$1500,0),"")

    This is the formula I tried and when I use the Evaluate formula feature, it never matches A13 to the correlating cell on student worker list. I entered the formula in B13 to test it.

    Any suggestions? If it is too much work, just let me know and I will manually check every time I input a new entry. I just figured this would save time.
    Test Spreadsheet.xlsx

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Formula to pull data from one sheet and column for another sheet.

    Nothing seems to match up in the file with your description of the problem....as far as I can see.

    There is sheet1 and sheet2 but nothing labelled Student Worker List or Student Worker Pay. What you sent seems to be related to courses and years.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,247

    Re: Formula to pull data from one sheet and column for another sheet.

    Agreed. Did you upload the correct workbook?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Forum Contributor
    Join Date
    05-29-2012
    Location
    Walnut, Ca
    MS-Off Ver
    Excel 2010
    Posts
    180

    Re: Formula to pull data from one sheet and column for another sheet.

    I attached the wrong file, but it's not allowing me to upload the correct file. I will try again in a bit.

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,247

    Re: Formula to pull data from one sheet and column for another sheet.

    if it is too large, try removing everything that doesnt relate to your question, and maybe reduce the number of records, too

+ 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: 0
    Last Post: 05-21-2013, 03:09 PM
  2. Replies: 4
    Last Post: 09-05-2012, 05:57 PM
  3. Replies: 4
    Last Post: 08-29-2012, 10:32 AM
  4. Replies: 0
    Last Post: 01-23-2012, 02:49 PM
  5. Excel / VBA - Pull data from one column to new sheet by ident #?
    By askew.j@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-02-2006, 02:40 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