Looking for formula that will confirm (True/False) that the (single
character) entry in col "C" is a valid entry for data in col "A". I have
setup a table that shows the 9 codes in col "A" (a, b, c, d, e, f, g, p, and
q) and the codes that correspond to them.

Any assistance appreciated

Thanks in advance.

=C1=VLOOKUP(A1,lookup_table,2,False)

--
__________________________________
HTH

Bob

"VAPCMD" wrote in message
...
Looking for formula that will confirm (True/False) that the (single
character) entry in col "C" is a valid entry for data in col "A". I have
setup a table that shows the 9 codes in col "A" (a, b, c, d, e, f, g, p,
and
q) and the codes that correspond to them.

Any assistance appreciated

Thanks in advance.

Hi,

You may need to get a little fancier because if the A1 entry is not listed
in the table the previous formula will return #N/A. In this case that
problem also displays FALSE.

=IF(ISNA(VLOOKUP(A1,$G$1:$H$2,2,)),FALSE,VLOOKUP(A 1,$G$1:$H$2,2,)=C1)
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"VAPCMD" wrote:

Looking for formula that will confirm (True/False) that the (single
character) entry in col "C" is a valid entry for data in col "A". I have
setup a table that shows the 9 codes in col "A" (a, b, c, d, e, f, g, p, and
q) and the codes that correspond to them.

Any assistance appreciated

Thanks in advance.