Excel Verification Formula

[rhoneyfi]

I have an Excel Spread Sheet that has the following sample info

Client Name Client Code
----------- ------------
Joe 1
Joe 1
Joe 1
Larry 2
Larry 2
Henry 3
Henry 3
Henry 3
Henry 3
Henry 3
Ziola 4

I need a formula that makes sure that the Client code is the same for the client name. Ex:

if for some reason when data got imported into Excel

Client Name Client ID
Joe 1
Joe 1
Joe 9 *** This sould signal some kind of
error message

 

[wwgmr]

hi

You could do this by using data Validation and write a formula that is a Lookup(Name,Client,2) That should look up the client name on your table and compair the value in second column. If they don't match you can get the error. You can find data Validation under Data then Data Validation.

Hope this helps.

Eric