Return more then 1 result lookup
Newbie to excel please help
I have a list of orders which I have to chase, it would make my life a lot easier if I could use something like v lookup to return the data to another worksheet (I would need all of the columns as I am planning to set up charts aswell with this data), for example if I was to enter the supplier name SAP at the top of the worksheet it would return a list of all orders for the supplier SAP.
I would then like to copy the formula across several worksheets so that I could have a different worksheet for each supplier. The main bulk of the orders have to stay on the 1st sheet (I have only put about 20 lines on this sheet but the original contains approx 2000 lines) as this is used by a lot of people throughout the company otherwise I would just have seperate tabs.
I have attached a copy if this helps
Please help if you can.
You can try Pivot table to do this task.
Originally Posted by waz70
See the attached file.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1