Using AND in Excel for large lists

[GallivantingOne]

Date	Start	End	Arena	Home Team	N/S/E/W	Away Team	N/S/E/W	Division	Bracket
04/03/2023	20:30	21:30	MPS	Kodiaks*	South	Kodiaks*	North	U11Div1	Go Here
04/04/2023	17:30	18:30	CDB	Avengers	West	Bumble Bees*	North	U11Div1A
04/04/2023	19:45	20:45	CMM	Screaming Squirrels	North	Bumble Bees*	North	U11Div1
04/04/2023	19:30	20:30	CTM	Cedars U13	North	Cedars U13	South	U9Div
04/04/2023	17:30	18:30	CVA	Condors	West	Condors	South	U9Div

I have a spreadsheet called "All Ice" and what I need to do is link the Division cells to the correct scheduling bracket located on another sheet. The other sheet is called "Scheduling Brackets". The Division field consist of a drop down box listing U9Div, U11Div1, U11Div1A, U11Div2, U11Div3, U13Div1, U13Div2, U13Div3, U13Div4, U15Div1, U15Div2, U15Div3, U18Div1, U18Div2, U18Div3

I am using =IF(I12="U11Div1",HYPERLINK('Scheduling Brackets'!F10,"Go Here"),"") and it works. When you click on the "Go Here" in the Bracket column it takes you to the U11Div1 sheduling bracket on the next sheet. The scheduling brackets for each of the above divisions are all on the same "Scheduling Brackets" sheet but the cell reference (F10) would change to locate the correct division.

Looking at this, I thought I could use AND to link all these IF statements for each of the divisions based on the selection from the Division column. The spreadsheet shown above is only 5 lines out of about 900. That seems to be a lot of IF / AND statements to copy down is it not? I've used Excel for a number of years but never to this extent. Any thoughts?

 

[AlphaFrog]

You could use the MATCH function to search for the row number of a Division label in column F of sheet Scheduling Brackets
Something like this...

=HYPERLINK("#'Scheduling Brackets'!F" & MATCH(I12,'Scheduling Brackets'!F:F,0),"Go Here")

 

[GallivantingOne]

Brilliant! Works like a charm. Thanks so much. I spent hours looking at all the different Excel commands to try and get this to work. So simple. Thanks again!