Forum Discussion

phitchman66's avatar
phitchman66
Copper Contributor
Oct 08, 2020

IFS with nested FIND formulas

New here so forgive me. I'm trying to use a formula to look for a text within a cell. Typically the cell will have  XX/6A/XXXX -or- XX/10A/XXXX -or- XX/16A/XXXX -or- XX/20A/XXXX -or- XX/32A/XXX...
Formulas and Functions
phitchman66's avatar
phitchman66
Copper Contributor
Oct 12, 2020

PReaganthanks, this worked a treat. I couldn't (well didn't want to add more data to an already congested data sheet) so I went with this.

Resources