Cross Reference multiple columns and copy

I am working with two sheets, Sheet one has 1 column of information with 12 columns to the right as categories. I want to be able to put an 'X' in any one of the 12 column rows, (category) and have a function that will copy/pastes the information from the main column (column #1, row=any) to the second sheet. I have tried True-False function, argument function, Vlook etc., I still cannot get it to work, any help would be appreciated.

Pls ignore solution did not work

Welcome to the forum, bsmith.

Please take a few minutes to read the forum rules about thread titles (and in general), and then amend your title accordingly.

EDIT your original post, and update your title to something clarifying the issue, it's a forum rule... something like "Cross Reference multiple columns and copy"

Then post up a MOCKUP of what you're doing, and include a mockup of your desired results. It makes it much simpler to just look at what your after instead of trying to decipher a description.

To attach a workbook, GO ADVANCED and use the paperclip icon.

Hoping to avoid needing to use array-type formulas, so I'm suggesting you replace the "X" approach with a numerical listing for each column on the Master 1995 sheet. This allows a totally normal INDEX/MATCH type formula to do the heavy lifting for bringing each "list" over to each sheet.

Have a look.

Unbelievable! thank you.

Can it be one numerical value like '1' reflective of my original intent 'X' constant. The sample I put online was reduced down to 15 rows, my original version has 935+ rows. A '1' will be easier on the eyes however will a redundant '1' do the heavy lifting? I have tried changing the 'IF' to get it to '1' on all rows but this is so far over my head. In addition I break the columns with reiteration of packages at every division for printing purposes and the function doesn't like this one bit.

Not a rocket scientist, just a blue collar worker trying to get two feet off the ground, literally...

You didn't adjust the formulas to include the new range. The formulas I used only went down 15 rows of data.

EDIT: workbook attached

I decided to go back to your original "X" approach and add a hidden "key" column between them to do the indexing. You can hide/unhide them by clicking the [ + ] symbols at the top of the page.

This sheet is HUGE, my friend, so there are always going to be performance issues when you're trying to keep 1000 rows of data updating in realtime against 15 sheets, not sure what to advise about that.

The individual sheets need the formulas copied down as far as necessary to show all the references...upwards of 1000 rows each, right?

<chuckle> Glad it's working for you.

If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED]