Hi,
I have an EXcel sheet, where in i have 2 spread sheets.The first one is display sheet where i want to get the values displayed from the second one which has all the data.

Example:
When the user enters an EMPLOYEE NO, the Excel sheet has to search for the EMPLOYEE NO stored as a list in the second spread sheet, and if found display all the details say his address,phone no etc.If not found it should display "NOT AVAILABLE"

So i need t write a formula, where in it validates the EMPLOYEE NO in the first spread sheet with that of the second spread sheet(which has a long list of EMPLOYEE NO's).

How do I do that.Please let me know