Mawar5530
06-28-2021, 10:21 PM
=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
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