I developed a formula to do such a search with multi criteria, th
code is below for you to study. Hopefully this helps and gets yo
closer to what you want. (note this formula is consumes a bi
recalculating time 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))
)


-Fable
It looks like that can get me started, but it is always returning 0.
went in and changed the return value to 1 and that's what came up. So
was wondering what CONCATENATE($B13
8,C$136),sheet1!$A:$A,0) was referring to. I'm assuming on your shee
you are using b138 and c136, where I am not, but I don't know what t
change that to for starters.

Thanks Fabl

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