Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Nov 01, 2012
user Grikgod said: (http://productforums.google.com/forum/?zx=gdxpen6jynp#!category-topic/docs/spreadsheets/CeB6GRaQEV4)
Looking up a value based on multiple entries in a single cell
for starters I have created a solution with a number of helper columns -- it is possible the formulas can be consolisated but I will leave that for another time.