if statements

[nighttrain20]

I'm trying to take the winners score (Baltimore) (21) and post it to "Sheet1 H20". I want formulas for this to be performed on "Sheet2" and once calculated go to, "Sheet 1 H20" Can I get help with this formula?

"This info is on Sheet1"
________ H4 J4
Baltimore 21 7 Buffalo





"H20"
Total ___

Thank you,

Tony

 

[Joe4]

On Sheet2, if you have the value "H20" in cell A2, and your want a formula that will return the value from that cell reference on Sheet1, you would use this formula:

=INDIRECT("Sheet1!" & A2)

Is that what you are looking for?
See this for more on INDIRECT: https://www.contextures.com/xlFunctions05.html

 

[nighttrain20]

On sheet2, I want to create the formula from the data on sheet1 . Sheet1-H4 has "21" in the cell & Sheet1-J4 has "7" in the cell And I know this is wrong but, =IF(H4<J4)

I want it to return "0"...If H4 is greater than J4 ((which it is)), I want it to return "21"

 

[Fluff]

Maybe
=MAX(Sheet1!H4:J4)
or maybe
=IF(Sheet1!H4>Sheet1!J4,Sheet1!H4,"")

 

[Fluff]

Cross posted https://www.excelforum.com/excel-general/1256168-returning-a-value-on-a-different-sheet.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.