Column L Column M
306TRFKM (THREE FORKS MIDDLE) B
306TRFKM (THREE FORKS MIDDLE) B
306TRFKL (THREE FORKS LOWER) #VALUE!


Formula for column M
=IF(FIND("MIDDLE",L1,1)>0,"B",IF(FIND("LOWER",L1,1)>0,"A"))

The formula only looks at the first "IF" statement and ignores the second. If I switch the IF statement so that I'm looking for "LOWER" first, it works for all the lowers but ignores the second IF and gives me a #Value for all of the middles.

Any idea why this is happening?