IFS Fuctions not working after second argument

I suspect there is a better way, but this works:

Formula:

Please Login or Register  to view this content.

Originally Posted by mjsabin

It works for RBM and HUM but when it gets to a JKE one, although if you evaluate FIND by pressing F9 and it comes out as true it still gives me #VALUE error.

It doesn't actually work for HUM. Per the documentation:

"If a logical_test argument is evaluated and resolves to a value other than TRUE or FALSE, this function returns a #VALUE! error."

That means that if RDB is not found, the first logical condition evaluated raises an error value, so your return value is the #VALUE! error.

If you can rearrange your results cells so that they are in the same order top to bottom as the priority of the search you want to operate, you could probably use a LOOKUP and FIND combination.