I developed a formula to do such a search with multi criteria, the cod
is below for you to study. Hopefully this helps and gets you closer t
what you want. (note this formula is consumes a bit recalculating tim
when copied over & over)

=IF(ISNA(INDEX(sheet1!$B:$B,MATCH(CONCATENATE($B13 8,C$136),sheet1!$A:$A,0)))=TRUE,0,INDEX(sheet1!$B: $B,MATCH(CONCATENATE($B138,C$136),sheet1!$A:$A,0)) )


-Fabl

--
Message posted from http://www.ExcelForum.com