Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search for multiple criteria, and return yet another | Excel Worksheet Functions | |||
Search Column Data and Return Multiple Values across Row | Excel Worksheet Functions | |||
search multiple sheets for specific date, return data in cell to r | Excel Discussion (Misc queries) | |||
Multiple search criteria to return one response | Excel Worksheet Functions | |||
search multiple worksheets for an item and return the Wsheets name | Excel Worksheet Functions |