I have created a phone book in Excel 2007. and using a vlookup i search a list and display results based company, last name, first name. I want to be able to display multiple results. for instance if i have 2 people in there called neil it will only display the first instance. any ideas??
bump bump x
in all honesty the best advice would be to use Pivot Tables and have the appropriate field (first name, last name etc) as a Report Filter field on each PT and the remaining fileds as Report Labels... else you're looking at potentially array formulae or helpers... a PT is designed for this purpose.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
I have a phone book list and on another sheet i would like to search it. i am using a vlookup but this only displays the first result found. Can anyone tell me a formula to display all the results. EG. if i search by company name, then i want all entries to be displayed based on that company.
Attached is my file.
I dont want to use this as a pivot table, does anyone know of a way to get this working?
which is perfectly fine however you should not start a new thread, simply reply on your old thread to that affect and await further responses.
CAn i get rid of the old thread
Threads merged.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks