Data validation - Validation List if statement

Try this ...

Named range "Errror" has text "Invalid Entry: Clients do not match"

in DV

Source: =IF(A2=B2,Status,Error)

If you need more than this you will need VBA.

Originally Posted by JohnTopley

Try this ...

Named range "Errror" has text "Invalid Entry: Clients do not match"

in DV

Source: =IF(A2=B2,Status,Error)

If you need more than this you will need VBA.

Thanks John!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.