I am not to sure if this can be done, but what I am trying to do is very similar to company phone book search. In excel, i have a list of names, department ID, email etc. In a seperate sheet, I would like the end user to type in a Dept ID and all the names, emails and phone numbers would be displayed below.

Any help would be greatly apriciated.


Drew

Hi

I think VLOOKUP function would do all the work

-vemaju