Looking up and reporting cell data if data from different cell is greater than 20

[GSI2013]

Here's a tricky one if it's possible...
This is a formula that will go into Sheet2 but is based off of Sheet1 data.
Sheet1:
M4 has a formula reporting a number.
C4 has a designated number for that whole row (this number is made without regard to the actual row number on the spreadsheet FYI)
Sheet2:
What I want is a formula to go into sheet2 that looks at the number in M4 (from sheet1). If that number is greater than 20, I would like the number from C4 (from sheet1) to be reported in the cell where the formula will go.

Also, I'd like to learn how to do this stuff on my own eventually. I'm very intermediate which means I'm familiar with formulas, can make very basic ones, and can operate Excel in a business setting. Is there a site you would recommend I read to advance my skills? Again, love the forum and very appreciative of the help!

[ConneXionLost]

Try this:

Please Login or Register  to view this content.

[GSI2013]

Thanks so much!
Now, where does a novice go to learn stuff like this?

[vlady]

Welcome to the forum.
Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as "SOLVED".
For the meantime I'll do it for you.

How?
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Note:
You can also thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given.
By doing so you can add to the reputation(s) of those who helped and shared their time in helping you.

[GSI2013]

Ahhhh good to know, thanks for the heads up!