LookupHelp.xlsx
Hi,
Please see attached file to help explain my question.
I want to lookup a value in a table (on a seperate sheet) but search for all occurences of the lookup value and return the sum of this.
So for example if I lookup Eggs in the table the formula will find this once and return 5, if I lookup Bread it will find this twice and return 7 (1 and 6 added together).
If someone can explain to me how to do this step by step it would be appriciated, I'd rather learn how it works than just get someone do the work for me.
PS. this needs to work in 2007 if the formulas are version dependent.
Thanks,
Harribone
Bookmarks