= if(and(Sheet1!b2= a2,sheet1!c2=b2),sheet1!c2,"")


"Sam_sebai" wrote:

Is there a way that I can search for a string without using lookup, I don't
want t o sort any columns or rows.

This is what I would like to do:

Search for if (Sheet1!b2= a2) and (sheet1!c2=b2) then place the string from
Sheet1$c2 in the current cell

This will be copied down to 100 cells in the current sheet.
I tried sumproduct, but it didn't work.
Thank you in advance