Hey guys,
In the attached sample file, I have two sheets. "Data" sheet is the source and "Summary" is the reporting sheet. I have four product A, B, C and D. A and B are Legacy products but have different price values as shown in the "Data" Sheet. My goal is to select the option "Legacy" from the list in "Summary" sheet so that the table next to the list displays the combined values for A and B. I have a column highlighted in the sheet "Summary" to show the expected output. Could anyone help me with this?
Any help is appreciated.
Thanks in advance
VJ
Bookmarks