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

 

[Habtest]

Slight change from your formula:

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

 

[mawar5530]

Still same the text or index not appear its shown as "0"

 

[Habtest]

Ah... I misunderstood the question.
what are in the target columns if not numbers, texts or number in text format? Would be good to see some examples.

 

[Habtest]

If the two criteria above returns one unique result, try

INDEX(sheet2!$K$2:$K$1000,MATCH(1,(sheet2!$A$2:$A$1000=A2)*(sheet2!$B$2:$B$1000=sheet1!B2),0))

Ctrl+Shift+Enter

 

[mawar5530]

Perfect and thank you so much to clarify and help me.

 

[Habtest]

Glad it works out, thanks for the feedback!

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Excel Formula : =MIN(IF)
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.