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?

"Max" wrote:

.. I just want it to flag it somehow if what is showing up in
Code 2 isn't in list of numbers to be used for the corresponding Code 1

This set up might get you going ..

First, create 2 columnar defined ranges: _1A and _1E
to refer to the respective lists

Then assuming Code1, Code2 data is running in A2:B2 down
you could place this in C2:
=IF(COUNTA(A2:B2)<2,"",IF(OR(AND(A2="1D",B2="MF"), AND(A2="1A",COUNTIF(_1A,B2)),AND(A2="1E",COUNTIF(_ 1E,B2))),"","X"))
Copy C2 down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
---