View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default 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.