I am trying to find the lowest value in a data set.
The data set to be searched is referenced based upon its ID which includes both the Project Name and its Subcode.
I tried using:
=MIN(IF($F$2:$F$9="*"&$B2&"*"&$A$2,$G$2:$G$9))
as an array, but it returns either 0 or - when the correct output should be 9.
Any help would be greatly appreciated! Thanks in advance!
Bookmarks