Google Spreadsheet Post #1101
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Apr 9, 2013
user Jared Morgan :(http://productforums.google.com/forum/?zx=dp8talaivacu#!category-topic/docs/spreadsheets/EmJJ7df_ifo)
Multiple Lookup and Get Function
Hopefully this will make sense and with the document even more so. I'm trying to populate projects!G:Y so that it grabs the appropriate (sometimes multiple) assets!D (loc) based on matching assets!BB:BL (PIDs) with projects!A and assets!E (asset_type) with projects!1.