Hi,
I need help quick!
I have a file with 2 worksheets: Worksheet "Data" contains Store Locations, Store Numbers, Categories, Brands, Sales, Clusters, % Demand, etc.
Under % Demand on Worksheet "Data", I need a formula to look for % Demand from Worksheet "Stores" that related to the same categories, brands and stores numbers.
Please help. Thanks a lot.
Vinnie
So you're looking for an instance where Categore, brand and store number all match your input values and then return the % demand?
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
NBVC,
I have attaching this file for you. Formula needed under Col G in Worksheet "Data".
Thanks in advance for your help.
Last edited by Vinnie Chan; 05-12-2008 at 01:20 PM. Reason: File not attached
Try again....
That attachment doesn't really help to answer my question...
also please post an excel sample.
I try to zip the file below 100 KB, and I've already removed most of the data but it still over 100 KB. That's why I try pdf it.
Please tell me how to attach the file.
Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks