I'm attempting to assign contract descriptions based on multiple elements of
the contracts. All data is in the same worksheet / same tab. I could use
some help developing a series of nested functions that compare data and pull
the correct description. Here's what I've got to work with:

Formula Objective:
Search the combination of Contract RCCC, PEC, and BAG codes and select the
applicable description if all elements are TRUE. If any of the elements are
FALSE, enter €œNot GWOT related€�.

Formula Conditions:
If the left 2 characters of RCCC Code (Column R) match anything in Column C,
Rows 2-33 then continue, if not, then match is FALSE.
If 3rd & 4th characters of RCCC Code (Column R) match the first two
characters in Column D, then continue, if not, then match is FALSE.
If PEC Code (Column S) matches PEC Code (either Column F or G) then
continue, if not, then match is FALSE.
If BAG Code (Column T) matches BAG Code (Column H) then continue, if not,
then match is FALSE.

Contract Codes:
RCCC Code Column R; Rows 2-4804, inclusive
PEC Code Column S; Rows 2-4804, inclusive
BAG Code Column T; Rows 2-4804, inclusive

Criteria:
6 Digit RCCC Code Column A; Rows 2-33, inclusive
RCCC Digits 1 & 2 Column C; Rows 2-33, inclusive
RCCC Digits 3 to 6 Column D; Rows 2-33, inclusive
PEC Column F or Column G; Rows 2-33, inclusive
BAG Column H; Rows 2-33, inclusive

Desired Description Column E; Rows 2-33, inclusive