Thursday, January 10, 2013

yogi_Combine In This Spreadsheetheet yExample1 Data Pulled By Model No From Spreadsheet Named yExample2

here is an image of the spreadsheet yExample2:
(click anywhere within the image to see a larger and clearer view of the spreadsheet)

                                          Google Spreadsheet   Post  #964
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Jan 10, 2013
thread started by gmckinlay and question by suser Zachary Yang :(https://productforums.google.com/forum/#!mydiscussions/docs/13P03U5Gg1s)
Spreadsheet formula to combine sheet data needed 
There are two spreadsheets, example1 and example 2. I want to add the data from example 2 into example by matching the model no. Thank you for your help!

example 2
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------

(here is an image of the spreadsheet yExample2)


(click anywhere within the image to see a larger and clearer view of spreadsheet yExample2)

following is a solution using two spreadsheets named yExample1 and yExample2