Search for data and return multiple fields

T

Tenshi

I have a massive spreadsheet of around 8,000 rows and tons of data. Is there
a way I can set up a separate worksheet as a front sheet where I can type in
the name of a company in a cell on the front sheet and it will search for the
name of the company in the data sheet and pull it up along with all the other
details of that company?

My main issue is that I'd want to use "*" in the search field and that there
may be multiple contacts for one company. Is there a way to start typing the
text to search for and have the cell autofill from the list of company names?

Using the filter option on the main data sheet would be best to find
everything quickly, but this is for our salespeople so it needs to be as user
friendly as possible and easy for them to print off.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top