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 1

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