I think...

Having read the thread and reread your initial post from yesterday
that the following is the formula you need to use in AK2 and copy
through to AK4804.

=INDEX($E$2:$E$33,MATCH(1,(LEFT(R2,2)=$C$2:$C$33)* (MID(R2,3,2)=LEFT($D
$2:$D$33,2))*((S2=$F$2:$F$33)+(S2=$G$2:$G$33))*(T2 =$H$2:$H$33),0))

This is an *array* formula. In AK2 commit with Shift+Ctrl+Enter. Then
copy down.

HTH
Kostis Vezerides


On Oct 15, 7:43*pm, Russ wrote:
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