search without using sort (lookup function)

[Sam_sebai]

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

 

[Dick Kusleika]

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,Sheet1!$B$1:$B$10,FALSE),INDEX(Sheet1!$C$1:$C$10,MATCH(A1,Sheet1!$A$1:$A$10,FALSE),1),"No
match")