password protected

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

can I secure a sheet when it's a vlookup design?
I have 2 sheets... sheet 1 is for my vlookup formula, sheet 2 is where
all my data reside and it's hidden.

now. *** 1 is interactive where-in users enter in an area code, hit
enter then it populates the data from the *** 2.

I tried password protection but if I did that, it won't let users enter
in an area code hence extract info. from sheet2.

what's my alternative?

.

Quantcast