Cross Validation

[xl_psychic]

Hi,

Would like to ask the forum members whether cross validation is possible in Excel.

For Eg: If I have names in Sheet1 and I want to validate a cell in Sheet2 to show the names which are there in Sheet1.

Thank You

Rohan Fernandes

 

[GorD]

Yes, I believe you can do this by using named ranges.

Give it a go.

 

[just_jon]

As GorD said, create a named range via --

Insert | Name | Define

Then, for your 2nd sheet, activate --

Data | Validatin | select List from the Allow box | enter your named range in the Source box and check In-cell dropdown

 

[xl_psychic]

Thanks a lot Just_Jon.. That was really helpful.