I am working on a calculated formula based on my [Tracking Number]
column to get the following results:
- Find "Andrews" return the result "ANDREWS".
- Find "Bolling" return the result "BOLLING".
- Find "Pentagon" return the result "PENTAGON".
The formula that I have come up with returns "ANDREWS" when it finds "Andrews", and returns #VALUE! for all the others.
This is the formula that I am using. Please help me resolve this issue.
=IF(FIND("Andrews",[Tracking Number]),"ANDREWS",IF(FIND("Bolling",[Tracking Number]),"BOLLING",IF(FIND("Pentagon",[Tracking Number]),"PENTAGON")))
Thanks in advance!