Hi,
Is there a way (formula) to compare all values (items) in a table at once (columns and rows; $D$2:$M$6) against 2 columns in a second table (items & items sold; $B$11:$C$500), and return the total amount (items sold) depending on a selection made with a dropdown list..?
However, I'd like to be able to change or add items in the 'green' table columns in the future whitout breaking the formula.
I think this is a real challenge, please see example for more info, because it's kind of hard to explain... ;-)
Thanks in advance..!
Bookmarks