# Result certain cols only , True False function

#### Sunline

##### Well-known Member
Hello all ,

Im wanting to get a TRUE FALSE function that will only look at the cols I want , not a range as such .

As per sample sheet my results col E , in this case I only want to look at cols A B D , not col C .

I want to add a few more cols than the 3 in sample but don’t know how to do this

Thanks .
Excel Workbook
ABCDE
11234Result
2FALSEFALSEFALSEFALSEFALSE
3TRUEFALSEFALSETRUETRUE
4FALSETRUEFALSEFALSETRUE
5FALSEFALSETRUEFALSEFALSE
6FALSEFALSEFALSETRUETRUE
7FALSEFALSEFALSEFALSEFALSE
8FALSETRUEFALSEFALSETRUE
9TRUETRUEFALSEFALSETRUE
10FALSEFALSEFALSEFALSEFALSE
11FALSEFALSETRUEFALSEFALSE
Sheet1

### Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
E2, control+shift+enter, not just enter:

=ISNUMBER(MATCH(TRUE,CHOOSE(ROW(INDIRECT("1:"&COUNTA(A2,B2,D2))),A2,B2,D2),0))

Thanks again Aladin works perfectly .
Thankyou .

Does not a simple adaptation of Aladin's OR formula as provided here, & noting the subsequent confirmation that Ctrl+Shift+enter is not required, suffice for your needs?

=OR(A2:B2,D2)

Thanks again Aladin works perfectly .
Thankyou .

You are welcome. But note...

Does not a simple adaptation of Aladin's OR formula as provided here, & noting the subsequent confirmation that Ctrl+Shift+enter is not required, suffice for your needs?

=OR(A2:B2,D2)

How true!

Replies
0
Views
110
Replies
2
Views
105
Replies
6
Views
169
Replies
4
Views
275
Replies
1
Views
251

1,207,439
Messages
6,078,569
Members
446,349
Latest member
Malroos7912

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back