I'm thinking this might help you.

http://www.contextures.com/xlDataVal13.html
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"Cathie" wrote:

I have a worksheet that is approx. 60 columns, and 6,000 rows ...

One of the columns is labeled Code 1; another Code 2. If there is a 1 under
Code 1, it should pull one of any numbers from a list (see below). I am
looking for a way to make sure it is pulling a correct entry ... in other
words, I want to flag it somehow if the entry is NOT in the list of codes.

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

If code1 = 1A, then code2 should = 65, 63, 74, 94, 86, 73, 47, 52, 83, RS,
76, 97, 78, 34, 51, CT, 39, 77, 55, 57, 58, CR, CM
If code1 = 1E, then code2 should = 90, 91, 93, 98, 54, MP, 42, 43, 56, 48,
49, 50, 46, 66, 67, 53, 96, CW
If code1 = 1D, then code2 should = MF

Is there a function that will do this for me?