Hello,
I am having trouble with a formula not returning a value, and I am not sure why. I am trying to return the minimum value where certain criteria is met.
The following formula returns the correct value:
{=IF(ISERROR(MATCH(C$13&$A14&$B$1,Sales[First Name]&Sales[EndState]&Sales[StartState],0)),"-","Good")}
However, when I add the part of the formula to return the min value it is returning as #N/A. Any suggestions on when the following is hitting an error?
{=IF(ISERROR(MATCH(C$13&$A14&$B$1,Sales[First Name]&Sales[EndState]&Sales[StartState],0)),"-",MIN(IF(Sales[First Name]=C$13,IF(Sales[EndState]=$A14,IF(Sales[StartState]=$B$1,Sales[Dollars])))))}
Bookmarks