With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Friday, February 19, 2016
yogi_Pull Into Sheet2 Data From Table In Sheet1 By Matching Headers In Sheet2 With Those In Sheet1
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.
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.