Hello:
Please refer to attached file.
Sheet2 has Profit and Loss Data for Stores
Store name is in column B of Steet1
Category is in column C of Sheet1 for each month.
I need a formula to get some of the important data in Sheet2 by selecting the store from cell A2 dropdown list.
The data I need i listed in column B of Sheet2.
Once i get this, then i can create a graph to quick view.
Let me know if you have any questions.
Thanks.
Riz
Bookmarks