=MIN(IF((A2=sheet2!$A$2:$A$1000)*(sheet1!B2=sheet2!$B$2:$B$1000),sheet2!$K$ 2:$K$1000,""))
i am comparing 2 column in diff sheet and would like to call for result in column k.
but this formula work for number not for text, can someone please help me here..