search for data

hi please look to attached file

Try this:

Please Login or Register  to view this content.

Waffa:

Although this can be done, there is not a simple formula to do it. That said, I am attaching a sample workbook that does what I believe you want. Sheet1 has entry information. Sheet 2 has the names that are N/A.

Check the file and let me know if you need any additional assistance.

Or using AutoFilter:

Please Login or Register  to view this content.

thank you very much for all my freind who reply me
but please can you explain the code because I`m not professional in excel I`m just simple user
thanks

Do you mean explain how to use the code?

If so, in your workbook, Press Alt & F11 to open the VB editor, Insert > Module and then paste the code into the large white space on the right hand side. I suggest change the name in the top line (currently x) to something meaningful. Then from the worksheet, Tools > Macros > Macros, select the macro and press Run.

BigBas has provided a formula solution.