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

1. ## 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.

2. ## 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.

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

Agreed. Did you upload the correct workbook?

4. ## 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. ## 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

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

#### 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