Error checking

[Ducttape19]

I am creating a file that will be used to calculate insurance premiums. There is a column that will contain codes that are used for almost all the calculations. What I am trying to do is have something that will say that the code typed into the cell is not in the table that has all the available codes. I have to create it so that new codes can easily be added to the list of available codes. If anybody has an idea leave em a post.

 

[Richie(UK)]

Hi Ducttape19,

Welcome to the board.

Have you tried using Data / Validation / List?