I am using an average formula in several cells and then trying to use an "index match" formula to return a cells info from a matching value. Why will the formula return an error if the result is from using an average formula (see attachment) but works if I use a result that does not use an average formula (hard number)? If I reverse the index match formula, it also works.
Bookmarks