In a Work Sheet there are tow sheets
On Sheet1 i have Five Columns
Employee Code | Employee Name | Model No | Offer Value | Market
Value |
On Sheet2 i have three Columns.

Model No | Offer Value | Market Value |
aaaaaaaa | 5000 | 10000 |
bbbbbbbb | 7000 | 11000 |
cccccccc | 8000 | 12000 |

What i have done is In Sheet2 I have colored the text in white color
and have also protected the sheet with password so that no one can
view the data in that sheet.
What I want in Sheet1 is Employee should enter their details like
Employee Code, Employee Name & Select Model No from the drop down box.
At Sheet1 In the Column of Model No i have added List Validation that
is connected to my Sheet2. So auto drop down is coming.
As soon as the Employee Selects the Model No from the drop down box
automatically the data is fetched and display. I am using vlookup
Function.
As i know that Employee would play with the Vlookup formula, i try to
protect the Sheet1 with the help of Password. But all in vain as the
List Validation gets deactivated. Its giving me a message stating "
The Cell or chart you are trying to change is protected and therefore
read only."

Can i have the remedy of the same.

Awaiting for your help.

Akash Maheshwari