Friday, February 19, 2016

yogi_Pull Into Sheet2 Data From Table In Sheet1 By Matching Headers In Sheet2 With Those In Sheet1

Google Spreadsheet   Post  #2041
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Feb-19-2016
post by: hoolamonster:!mydiscussions/docs/tFirlL77KoE
Get Rows if Column Headers Match
I have two tabs, One is my master/control, the other tab needs to contain the same info minus some columns. (master has some sensitive info)

For the life of me I cant figure out a formula that basically does this:

If A2:BR2 (column header row) matches Master!A2:BR2 get rows/cells that belong to that column

I've been mixing different vlookups and filters and the combo of both in if statements, you name it, but I cant seem to get what i think should be easy, to work.

obviously I can write a query but I just hate listing the column letters out, it just gets long.

Any help would be awesome thank you

I would like to keep this entire thing dynamic, so if info changes on sheet1 sheet2 updates. and I would LOVE to do this with one formula, not pasting per column or using query and listing a million columns.