Max,

Good job! This is fascinating. I was once told that MATCH( ) is one dimensional. When I first saw $C$1:$E$3 as an argument in the MATCH( ), I thought two dimensional was happening. Then, when I looked deeper, I realized that the two-dimensional array is actually the lookup_value and not the lookup_array. The lookup_array is a single cell - F1, G1 and H1 respectively. I have never seen anything like this. So, the lookup_value can be an array provided SUMPRODUCT( ) is called, right? A single cell can be the lookup_array in any MATCH( ), right? I tested it and it seemed to be the case. Please enlighten/educate me if you don't mind. We still won't label the MATCH( ) two dimensional. Correct?

A general question on IF( ):

As long as the condition returns a value greater than 0, then it is TRUE, right? It doesn't have to be 1. Please correct me if I am wrong.

I am wondering if another solution would be INDEX(MAX(ROW etc. I may be off.

Enjoy your Monday!

Epinn

"Max" wrote in message ...
You're welcome, Luke !
Thanks for the feedback
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Luke" wrote in message
...
Thank you Max, Worked great! I didn't see the 359 when I built my example.
Fantastic!
Thanks again
Luke