All,
So i have a drop down list that i have been trying to use the INDIRECT function on.
The reason why it isn't working is because i want the indirect function to come from 2 cells.
Eg.
I have linked some team names to their respective player lists via naming.
Cell A4 has a drop down list of team names
Cell B4 has text "vs"
Cell C4 has a drop down list of the same team names
Cell E4 is where i want the INDIRECT function to go. I want it to display both selected teams player lists and select a player from either team. I want to be able to select the best on ground and from this need to be able to choose from both teams.
maybe the solution is not using the INDIRECT function.
Please help before i tear all the hair out of my head.
Bookmarks