Tuesday, August 6, 2013

yogi_Match Column B Values In Sheet1 With Those In Sheet2 And Populate Columns G to L Of Sheet1 For Matches In Sheet2

                                          Google Spreadsheet   Post  #1317
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug, 6 2013
user  WGalter (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/3H20f5EoA7s)
Arrayformula/Query not working as desired
Hello to all of the brilliant individuals of this forum.

I have this spreadsheet with two sheets "Sheet1" and "Sheet2" 
On "Sheet1" cell "G2" I have this formula.


=arrayformula(iferror(vlookup(B2:B;Sheet2!A2:F;{2}*sign(row(B2:B));false)))

What I like to do is, have this formula lookup the values on "Sheet1" column "B" and look for a match on "Sheet2" column "B" if a match is found I like the corresponding row to populate on the column "G:L"  on "Sheet1".

This is the link to the spreadsheet with some fake data!

Something is off with this formula what do I do?

Thank you in advance!

Have a Magnificent Day!
WG
------------------------------------------------------------------------------------------------------------------------------------------