Hello All,
Here is the sample DATA in range (B2:B10)
<colgroup><col></colgroup><tbody>
</tbody>
I want formula in Range (A2:A10)
I am using this formula in cell A2 to return 1 if the condition is met
All I want is to search if multiple entries are there in cell B1
For example To, Duca
Thanks in Advance
Regards,
Humayun
Here is the sample DATA in range (B2:B10)
Toyota |
Suzuki |
Suzuki |
Yamaha |
Toyota |
Toyota |
Suzuki |
Ducati |
Ducati |
<colgroup><col></colgroup><tbody>
</tbody>
I want formula in Range (A2:A10)
I am using this formula in cell A2 to return 1 if the condition is met
Code:
[B]=IF(ISNUMBER(SEARCH($B$1,B2)),1,0)[/B]
All I want is to search if multiple entries are there in cell B1
For example To, Duca
Thanks in Advance
Regards,
Humayun