Don't be so quick to dismiss the earlier suggestion as not helpful ..
(I think I did catch the gist of what you were facing & wanted done)

Ok, based on the details in your original posting,
aren't these the results that you expect to be flagged? :

Code1 Code2 Flag
1A 65
1E 42
1D MF
1A CT X
1E 90
1E 95 X
1E 50
1A 39
1A 77

How about an implemented sample to illustrate
the above set-up working properly:

http://freefilehosting.net/download/42671
Flag If inconsistent with Code list.xls

Take a closer look at the above, then do the correct rating on the response.

But I'm not counting ..
Neither was I. In the suggested expression, COUNTIF is used to check whether
col B's item appears within the Code2 listing corresponding to what's in col
A (1A, 1E). If the item appears, then the COUNTIF, eg: COUNTIF(_1A,B2) will
evaluate to a number greater than zero, ie an equivalent to TRUE.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
---
"Cathie" wrote:
But I'm not counting ... I want it to look in A2 - Code 1(as an example) to
see what number is there (nothing I typed in, it was imported from a
mainframe database) ... I want it to look in a LIST to make sure Code 2 is
the correct Code 2 setting. There could be 19 codes under Code 1 (A2) and
possibly 102 under Code 2. I'm not getting a lookup to work correctly as
these code 2s could apply to more than one different Code 1 number, so I
can't tell it to go to a certain column after it finds a match. I just want
to make sure that Code 1 agrees with whatever Code 2 number the mainframe is
generating.

Did that help or confuse everyone more?