Hello, I am looking for some help around my Company Directory.

I want to be able to have a user friendly search function, which searches my second worksheet to pull up staff info. I've been googling all afternoon, and made a million formula changes, and cant get it to work.

here is my sheet 1
first.JPG

my sheet 2 is where I keep all the raw data
second.JPG

How can I get this to work? I know its possible! I haven't worked with these types of formulas in YEARS, and feel like ive forgotten everything. HELP

Is it evev possible to email the document to a professional and have them code it? at my wits end!

Becca