Hello

You don't say what version of Excel you have, but if its 2007 onwards then try this in Cell A1:

=IFERROR(IF(FIND("Exempt", A2&A4&A6&A8&A9&A10&A12), "Exempt"),IFERROR(IF(FIND("Level 2", A2&A4&A6&A8&A10&A12), "Level 2"),IFERROR(IF(FIND("Level 1",A2&A4&A6&A8&A10&A12), "Level 1"),"")))

HTH

## Bookmarks