Search for data and return multiple fields
 

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.

Search for data and return multiple fields
 

Have a look at this site and check out the Function"Vlookup" or maybe a
"User-Form" plenty of information on Filters.
http://www.contextures.com/tiptech.html
HTH
John
"Tenshi" wrote in message
...
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.

Search for data and return multiple fields
 

Hi John,

Thank you - I'd never even come across advanced filters before!

T

"John" wrote:

Have a look at this site and check out the Function"Vlookup" or maybe a
"User-Form" plenty of information on Filters.
http://www.contextures.com/tiptech.html
HTH
John
"Tenshi" wrote in message
...
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.