Can you explain more clearly what you want? Give examples of data and columns
plus the logic required. e.g If A2= xyz then ......

"CJB" wrote:

I want to enter names in one worksheet and display "full" in another? Can
anyone tell me how to write this formula?