View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
trunzop trunzop is offline
external usenet poster
 
Posts: 6
Default Validation of Account Numbers

I ma reparing a budget entry sheet with numerous general ledger account
numbers in column A. I want to validate that column A has accurate general
ledger accounts numbers. How can I compare each cell in column A to a
general ledger account code listing,let's say in colmn M? If the account code
in Column A is not in column M, then it would either stop or provide an error
listing where the comparison failed. Is this a "If-then" statement? If so,
how do I code it?