how can i search for a string in a selected column without using lookup
function:

Here is what I need:

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.


Thank you so much