Splitting Multiple Choice

Dear Team,
I reach out to you to request your support !

How can i use this formula if i have TWO sheets like below:
- The rows on sheet2 correspond to the same row on sheet1
- The data on both sheets aren't start in cell A

As per my Excel sheet attached, could you help me with a formula that can allow me to splitting multiple choice in multiple colomns.

I can get result only for one colomn but i would like to get results for 2 or 3 colomns.

Thank you for your support.

Hi,

I'm not sure I understand what you're looking for, but by modifying your formula, it searches in both columns:

=ISNUMBER(SEARCH(C$1,'Two colomns'!$B2&'Two colomns'!$D2))