Searching a cell and setting another cell

Closed
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
I have a spreadsheet and on column A there are about 20 different project status (e.g - roadmap, mandate, startup, feasibility, definition....)

I want column B to be set to a vaule based on what was in column A.

For example - if column A is = to roadmap set column B to roadmap, if column A = startup or feasibility or definition then set column B to Planning. If column A = Build or deploy then set column B to Building.

Any idea how to acheive this?

Thanks!



1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
769
Use IF statements

=IF(A2="roadmap","roadmap",IF(OR(A2="startup",A2="feasibility",A2="definition"),"Planning",IF(OR(A2="Build",A2="deploy"),"Building","none of the choice")))