Hi team:

Im new to this forum & relatively new to complicated excel problems.

Scenario is:

In sheet1, I have column A & B which has values like:

10 1000
11 1001
12 1002

In sheet 2 of the same workbook, I want to place a restriction that the user should only be able to enter the above values in the same combination like:

10 1000 -- is valid
10 1001 -- is invalid
11 1001 -- is valid
11 1002 -- is invalid

i tried using the data>validations & was successful in restricting the values to one column. but how to restrict the values in combination?

Thanks.