Hello.
I need a formula in the sheet “Template” for each of the cells F9:F24.
For each group in these cells, the formula will look at the version number in in the drop down box in E3, AND the Season number in cell E5.
Then it will go to the worksheet “GROUPS”, & look for that version in row 2 & then look for that season in column A. When it finds the match it will retrun the value for each group in those cells F9:F24.
Any help would be much appreciated.
Try this formula in F9. It must be confirmed with CTRL+SHIFT+ENTER not just ENTER. And then copy it down.
=INDEX(GROUPS!$A$2:$AG$82,MATCH(1,(GROUPS!$A$2:$A$82=$E$5)*(GROUPS!$B$2:$B$82=$E9),0),MATCH($E$3,GROUPS!$A$2:$AG$2,0))
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Can you put that formula into the worksheet I attached & resend it back to me.
Thank you
Here you go!
You're a genius.
Many Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks