yogi_Match Data In Columns Of Different Sheets And Combine Data Into Another Sheet

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
user gmckinlay said:
Spreadsheet formula to combine sheet data needed
Hi,

I need a formula that combines data from 2 sheets in a 3rd sheet based on data in a common column in the 1st two sheets. This combined data is only certain columns from each of the sheets.

Sheet 1

Column A | Column B | Column C

Sheet 2 

Column 1 | Column 2 | Column 3 | Column 4

Sheet 3

Column A | Column 2 | Column 3 

Where Column B = Column 2

Thanks in advance for the help.

---------------------------------------------------------------------------

following is solution to the problem