Hi, My Cross Sheet formula =IF( is displaying the same results when I drag formula down dest column

John Ciarrochi

Here is a snippet of the Master Sheet, in the Category column I'm only needing the ones that indicate "consumable".

Paul Newcome

No. I mean add all of the extra columns that are solely on the Consumables sheet to the Master sheet. Hide them on the Master sheet. Create a report based on the Category column containing "consumable". Then you can pick and choose which columns are shown in the report even if they are hidden on the Master. Using this route, the Report replaces the Consumables sheet.

John Ciarrochi

Here is a snippet of the Consumable sheet, the highlighted columns indicates the columns that mirror the Master sheet and I would like to be pulled into this sheet automatically.

Paul Newcome

Ok. SO take the columns that are NOT highlighted, add them to the Master Sheet, then hide them.

Then create a new Report that looks at the Master Sheet. In the "What?" section, select the Category column and then enter a criteria of being "consumable". Then click on the "Columns" button in the Report Builder and select whatever columns you want displayed to include the columns hidden on the Master Sheet.

John Ciarrochi

Hello Paul,

Thanks for your insight, I will certainly contemplate that course of action with the user.

Paul Newcome

Happy to help. 👍️

John Ciarrochi

That is a great alternative, however I'm still curious to why my cross reference formula only worked when selecting referencing a single cell and got an error when trying to reference the entire column?

Paul Newcome

Both ranges need to be of the same size. So if one is a single cell and the other is a full column, you will get an error.