Hi Folks,
I'm sure this is pretty basic to some, but I'm trying to confirm the best way to go through all rows of data and if columns F, O and V contain specific strings then write something to column Z. Then if those same columns contain something else, write something to column AA
Basically:
ie:
The # of rows will vary so will have to determine rows then search in Column F O and V for values.
Any starting ideas and I'll run with it from there.
Cheers,
I'm sure this is pretty basic to some, but I'm trying to confirm the best way to go through all rows of data and if columns F, O and V contain specific strings then write something to column Z. Then if those same columns contain something else, write something to column AA
Basically:
- if F="a value" or "another value" AND O ="one of 6 values" AND V = "one of two values" then place Yes in Z,
- if F="a value" or "another value" or "a third value" AND O ="one of 6 values" AND V = "one value" then place Yes in Z,
ie:
Column F | Column O | Column V | Z | AA |
Cat or Dog | Red or Black or Brown | house or condo | Yes | |
Cat or Snake | Red or Black or Brown | house | Yes |
The # of rows will vary so will have to determine rows then search in Column F O and V for values.
Any starting ideas and I'll run with it from there.
Cheers,