Need a formula that if K2 & M2="Nil" & H2 doesnot contain the word sold index match on two critiria?

[tonywatsonhelp]

Hi Everyone,

Ok so I need a formula to do this

if K2 & M2 both contain the word "Nil" & H2 doesnot contain the word "sold" index B:B Match D2, sheet data D:D, & F2 to

sheet data f:f

thanks

Tony
​

 

[Norie]

Tony

Based on what you posted, perhaps something like this.

=IF(AND(K2="Nil",M2="Nil",H2<>"sold"),INDEX(B:B,MATCH(D2&F2,Data!D:D&Data!F:F,0)),"")