The attached file has three formulae in SHEET1. SHEET2 has a list of ingredients in column A. I want to look in the formulae in SHEET1 for the value in that is in column A of SHEET2 and place the number of occurances in column B in sheet two. So, the expression in the cell SHEET2!B1 should contain the number of times "EPA" shows up in SHEET1. I can't figure out how to write an expression that will take the string in column A and use it for the search, rather than me typing it in.
|