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
Bookmarks