Formula to confirm entry in Col "C" is valid for data in Col "A"
=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.
|