Tuesday, January 17, 2012

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
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