Vlookup

[golfgod]

I have a range of cells in a column that contain the text "In Process" and "Completed". I want to search or vlookup the cells and return "In Process" if any of the cells in the range indicate "In Process". If all of the cells indicate "Completed" I would like to return the value "Completed".
A
Formula
Completed
In Process
In Process
In Process
In Process
In Process
In Process

 

[etaf]

=IF( countif(A:A, "in process")>0, "in process" , "completed")

this assumes if there is no "in process" then it must all be completed

 

[golfgod]

=IF( countif(A:A, "in process")>0, "in process" , "completed")

this assumes if there is no "in process" then it must all be completed

Thank you very much. That worked perfectly!

 

[etaf]

your welcome