Hey All!
In the below formula I am trying to return the minimum value in column AH that has the criteria of B37 in column G. The formula is not properly finding the values in column G that meet criteria B37. Could someone help me to fix this?
=--(INDEX(Pricer!G:G,C$4):INDEX(Pricer!G:G,D$4)=B37)--MIN(INDEX(Loans!AH:AH,C$4):INDEX(Loans!AH:AH,D$4))
Thanks!!
Bryan H.
In the below formula I am trying to return the minimum value in column AH that has the criteria of B37 in column G. The formula is not properly finding the values in column G that meet criteria B37. Could someone help me to fix this?
=--(INDEX(Pricer!G:G,C$4):INDEX(Pricer!G:G,D$4)=B37)--MIN(INDEX(Loans!AH:AH,C$4):INDEX(Loans!AH:AH,D$4))
Thanks!!
Bryan H.