Data validation - Validation List if statement

Hi,

I am trying to use Data Validation - Validation List in C1. However, I want only users to choose from the list if A1=B1. If A1 is not equal to B1, an error message should show and the users cannot choose from the list. How do I do it?

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on "Reply" then GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Originally Posted by JohnTopley

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on "Reply" then GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hi John,

Apologies. Please refer to attach. Basically, from C2 to C5, users can choose from validation list because Column A = Column B. Except for C3 because A3 is not equal to B3. Hope this information is enough. Thanks

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.