I do not understand the relevance/meaning of the lookup_value and the lookup vector in the following formula from my previous (reloved) post (link below):
=LOOKUP(2,1/((Data!$A$2:$A$10=A2)*(Data!$C$2:$C$10=B2)*(Data!$D$2:$D$10=C2)*(Data!$E$2:$E$10=D2)),Data!$B$2:$B$10)

I tried changing these values and was able to get the desired result if the lookup value remained less than the number preceding the / in the lookup_vector. I also tried to change the / to "*" which gave me a result each time because the lookup_vector always seemed to be larger than the lookup_value.

http://www.excelforum.com/excel-gene...html?p=2709440

Thank You,
Chris