I am trying to do an INDEX-MATCH where the array can be switched between sheets based on the name in cell S13.
Here is my Formula:
=+INDEX(INDIRECT("'"&$S$13&"'!M2:M131"),MATCH(Sheet14!$M14,INDIRECT("'"&$S$13&"'!B2:B131"),0),0)
The result of the INDIRECT Portions are volatile.
The different sheets are all Data from the Web. I don't know if that is my problem or not.
Any help would be appreciated.
Bookmarks