I believe "1" is the value which is being looked up here.
Yes, that's correct

So, this formula searches "1" in the range D2 to D7.
Afraid not. MATCH(1,lookup_array,0) searches for the exact match of the "1"
within the lookup_array: (A10=$B$2:$B$7)*(B10=$C$2:$C$7), not D2:D7.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---