In E4 I have a basic index/match formula where the result is calculated based off of the red cells. The light blue cell has an exercise number in it. If the exercise number is found in the Chart 1 listing, I want the formula to index Chart one, if the exercise number is found in the Chart 2 Listing, I want the formula to index Chart 2 and so on.
Bookmarks