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     www.energyefficientbuild.com.   Feb-19-2016
post by: hoolamonster:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!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
---
https://docs.google.com/spreadsheets/d/1JvU805Fu-8v4np81F-CFlPM5mWQYAZ4DjtfaoB1epe0/edit?usp=sharing

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

No comments:

Post a Comment