On Thu, 20 Mar 2008 06:47:00 -0700, Sam_sebai
wrote:


if (a1=sheet1!a1:a100) and (b1=sheet1!b1:b100) then put in the current cell
the value of sheet1!Cxx where xx is the row that the condition was met.

What if a1 and b1 are found on different rows? Try this

=IF(MATCH(A1,Sheet1!$A$1:$A$10,FALSE)=MATCH(B1,She et1!$B$1:$B$10,FALSE),INDEX(Sheet1!$C$1:$C$10,MATC H(A1,Sheet1!$A$1:$A$10,FALSE),1),"No
match")
--
Dick Kusleika
Microsoft MVP-Excel
http://www.dailydoseofexcel.com