Hello, does anyone know how to use the LOOKUP formula to read a cell if it
contains something.

For example, I have a list showing cad engineer, then on the next row CAD,
the next row Cad technician and so on, all with different descriptions of CAD
In rowns A1:A100

I want my cell to equal CAD if call A1 contains CAD.

I also want it to read other words, like if it contains cad equal CAD, if it
contains ADMIN equal ADM etc....

Thank you! :)