please edit my search formula

[Jagat Pavasia]

i have formula already working,
but i want to add something in it.
pls help me.

=IF(ISNUMBER(SEARCH($I$1,B5)),F5,"") (already working)



I want to also add (search($k$1,A5) in upon formula

 

[AlanY]

may be

=IF(or(ISNUMBER(SEARCH($I$1,B5)),ISNUMBER(SEARCH($K$1,A5))),F5,"")

 

[Jagat Pavasia]

the formula is working but
i want that " if both are equal then answer, but on of them is not equal then leave blank)
$i$1=b5 and $K$1=A5 then answer only


pls help

 

[AlanY]

ok, change the OR to AND should work

=IF(AND(ISNUMBER(SEARCH($I$1,B5)),ISNUMBER(SEARCH($K$1,A5))),F5,"")

 

[Jagat Pavasia]

Thank you very Much BOSS, this is working for me as i want....

thank you so much again...

 

[AlanY]

you're welcome