If & Or Possibilities

Copper Contributor

I have a very old software system that makes parsing and cleaning up the downloaded versions nearly impossible sometimes. I have 5 properties, each with their own names. They are all listed as property 01, 02, 03, 04, or 05. I wanted to use an if formula that would say if the cell = (01, "xxxx", 02, "xxx", and so on. I can't seem to get the formula correct. I got it to list all five properties, or NA four times with the property name once, but I only want one listed. Can anyone help me with this formula, or maybe another formula that might do the same thing. 

 

1 Reply

@msouza1985 Perhaps you can upload a screenshot showing how the data looks like and clarify how the end result should look like.