erutherford
Active Member
- Joined
- Dec 19, 2016
- Messages
- 449
This is the code that is on the worksheet "Scores" with all the data.
I want to display the results on another worksheet.
"Entry" is the piece of data I want displayed on another worksheet. I thought pasting the above code into a cell on the other worksheet, adding "Scores!Entry" would require the formula to look at the scores worksheet, then post the results. Not happening. Is there another place I need to add "scores!" I tried adding it in front of "Pts" but that didn't work. BTW I did control, shift, enter each time.
Thoughts?
Code:
=IFERROR(INDEX(Entry,MATCH(1,(B56=Div)*(B57=Model)*(MAX(IF(Div=B56,IF(Model=B57,Pts)))=Pts),0)),"x")
I want to display the results on another worksheet.
"Entry" is the piece of data I want displayed on another worksheet. I thought pasting the above code into a cell on the other worksheet, adding "Scores!Entry" would require the formula to look at the scores worksheet, then post the results. Not happening. Is there another place I need to add "scores!" I tried adding it in front of "Pts" but that didn't work. BTW I did control, shift, enter each time.
Thoughts?