Searching a cell and setting another cell

Closed
stacks - Apr 23, 2010 at 09:09 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 23, 2010 at 12:48 PM
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 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 23, 2010 at 12:48 PM
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")))
0