# Pulling Data from a sheet based on criteria on both those sheets

1. ## Pulling Data from a sheet based on criteria on both those sheets

In my attached workbook I have two names on each of the two sheets. On the Stats Sheet I have the two names with a list of statistics. I want these statistics to pull to the Board Sheet based on criteria entered in Column H of the Board Sheet.

I've included minor further instructions in my worksheet. It's probably a really quick fix just not exactly sure how to get there. Thanks for any help!

2. ## Re: Pulling Data from a sheet based on criteria on both those sheets

Your "Board" sheet has data filled in already. Where do you want the formulas?

3. ## Re: Pulling Data from a sheet based on criteria on both those sheets

Originally Posted by NS4Excel
Your "Board" sheet has data filled in already. Where do you want the formulas?
It does but do you see how for the second player it doesn't replicate the values of that same player on the Stats page because they are located in columns N thru X not C thru M like the first player listed. I have the same formulas entered for both players because they need to show up in the same columns that's why I need it to specify if it should look up columns C thru M or N thru X based on the criteria for each player in Column H.

4. ## Re: Pulling Data from a sheet based on criteria on both those sheets

So, in the Board sheet in cell I3, you want whatever's in the Stats sheet cells n3-X4 if:
Board H3 does not equal SP, RP or P
Stats column B = Board D3
Stats Row 2 = what?
Is this correct? If so, tell me what the Stats Row 2 need to equal on the Board sheet.

5. ## Re: Pulling Data from a sheet based on criteria on both those sheets

Cell i3 is formatted correctly, cell i4 needs to reference columns n:x of the stats board because it has an SP in cell H4. Does that make sense? Thanks

6. ## Re: Pulling Data from a sheet based on criteria on both those sheets

Stats.xlsxSee if the attached file works for you based on the cells highlighted in green.

**If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of the posts.

7. ## Re: Pulling Data from a sheet based on criteria on both those sheets

Originally Posted by NS4Excel
Attachment 375451See if the attached file works for you based on the cells highlighted in green.

**If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of the posts.
Yes the right values are pulling but the formatting is wrong. In your Green Cells, cells R21 and S21 should only have two decimals, and all the other cells with three decimals should be whole numbers. Cells L20:O20 are formatted correctly as well. Thanks!

8. ## Re: Pulling Data from a sheet based on criteria on both those sheets

I'm confused. First off there is no R21 and S21 in the file I sent you. The green highlighted cells are in rows 17 and 18. Also, I used your instructions highlighted in blue on the Board sheet. Those instructions read:
IF Cell H3:H4 equals anything other than SP,RP or P please make columns L:O of the Board Sheet use the format with the .000
IF Cell H3:H4 equals SP,RP or P than match columns R:S of the Board Sheet use the format with 0.00

Row 17 has OF in column H so the cells are formatted to .000 and row 18 has SP in column H so the cells are formatted to 0.00.

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