I need help with excel Table and Vlookup or index or match.
I have 2 columns of data. Column A has a list of items repeated number of times. Each of these items can have multiple sub-items (can be repeated)associated with it and its price and qty. I would like to create a table with only unique items and sub-items with a yes/no or prices or qty info in the table.
is there an easy way to do this.
