Excel Formula : =MIN(IF)

[Mawar5530]

=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..

i also try below, still giving me "0" value

=MIN(IF((sheet2!$A$2:$A$1000=A2)*(sheet2!$B$2:$B$1000=sheet1!B2),sheet2!$K$ 2:$K$1000,"")) 2869128692

[Bob Phillips]

In what way does in not work? You are comparing text, but the MIN works on numeric values, so all is fine as far as I can see.

[Bob Phillips]

Did you array-enter it (Ctrl-Shift-Enter)?