# Data validation if Worksheet_change

#### Toto Li

##### New Member
Hello all!
I have 4 rows : Name, Address, E-mail, Phone ws2.Range("AN3:AN6")
Data exist: ws4.range("L8:AB5000")
Idea: Check if the customer has been registered with any of these details when cell value change: List.Show when Workshhet_change
Problem 1: The list should be displayed only once from any row, if more then one data matches.
Problem2: This range is also used to view the existing record. List does not need to be displayed.
Any idea for solution?

### Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

#### RayFrye

##### Board Regular
It has been some time and no one has helped you. I would suggest that you chop your requirements up into tiny pieces. This will allow you to think thru your requirements and someone here to get a handle on where you start, what happens in the middle (multiple steps) and how you might end the effort before the cycle starts over. I think most folks here want to help but many of us are programmers and we think in terms of formulas, forms, key strokes, subroutines and error processing. When we think about Excel apps our heads explode until we get the app to subroutines, then we can do our thing. Just a thought. And try something yourself and let us know where your thought process failed. Not too many here, although there are some, will sit down and write the app for you.

#### mumps

##### Well-known Member
It would also be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheets. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).

#### Toto Li

##### New Member
Thank you!
Problem is solved.