Hi There, I want to check text box value if matches between range defined accordingly..
Example
I have detail already given as under,
Now i want to check Text box1 value which is ABC in Columns A
& check if text box2 value is within range of Column B to Column C Value if yes than ok if not Error Msg.
Can any one Guide
ABC can be more than once so all matches should be checked.
Example
I have detail already given as under,
COLUMN A | COLUMN B | COLUMN C |
ABC | 101 | 200 |
DEF | 301 | 400 |
Now i want to check Text box1 value which is ABC in Columns A
& check if text box2 value is within range of Column B to Column C Value if yes than ok if not Error Msg.
Can any one Guide
ABC can be more than once so all matches should be checked.