Assign value based on another
Posted by Allision on December 07, 2001 2:37 PM
I want to assign a cells values based on whether or not another "contains" a certain string.
If cell in H:H contains "Dev" then 17 Else
If cell in H:H contains "Pro" then 11 Else
I'm thinking a select statement would work, but am not certain how to write it.
P.S. I say "contains" Dev because the cell in question could have a value or Dev or Developer, or Learning Developer, etc