Searching against multiple fields in a single row, populate new field in same row

[Diane Hogue]

I have two (2) different issues that I need help with. This is question #1 or part 1, of 2 parts:

In the first scenario, I have three (3) columns of data: Originating, Terminating and one for the formula. I need to be able to search one (1) ROW at a time (not columns), and look for a specified value in EITHER A2 or B2. If the specified value does exist in one of those cells, I need to populate C2 (same row) with a value of "True" or blank. If the specified value does NOT exist in either A2 or B2, then I need C2 to be populated with "False"

ex: I'm looking for 0066 in EITHER A2 or B2. It doesn't exist in either cell, so I'd like C2 to say "False"
0066 does exist in A3, so I'd like C3 to either be blank or be populated with "True"
0066 does exist in B3, so I'd like C3 to either be blank or be populated with "True"

It is not uncommon for these particular spreadsheets to contain 60,000-70,000 rows of data, and numerous columns, so searching manually eats up man hours. What I've done in the past is a series of filters to get to the answer I need.

Ultimately, I'm trying to get to a point where I can delete all the rows where column F is False.

[JohnTopley]

Try

=IF(AND(A2<>"0066",B2<>"0066"),"FALSE",IF(OR(A2="0066",B2="0066"),"TRUE",""))

[Diane Hogue]

It is kind of a duplicate, but there is one additional condition to be met. .

[JohnTopley]

Your other post ..

=IF(A2=1,B2,C2)

[Diane Hogue]

Ok, that part of it did work. . . how can I add the OR part of it. . .

If A2 equals 1, then populate D2 with B2, BUT if A2 equals 2, then populate D2 with C2??

There is where I get really lost. . .when I try to nest functions inside other functions.

[JohnTopley]

If A2 equals 1, then populate D2 with B2, BUT if A2 equals 2, then populate D2 with C2??

That is what the last formula does

in D2

=IF(A2=1,B2,C2)