Home > OS >  Query or ArrayFormula to return Column 1 when Column Headers in an Array = specific cell
Query or ArrayFormula to return Column 1 when Column Headers in an Array = specific cell

Time:12-11

For the life of me I couldn't figure out a search string to address this so apologies if it's been done.

I have a budget workbook consisting of 4 tabs: 1 for each of 3 departments and 1 that pulls data from the others to let you compare departments side by side.

A sample version with only the comparison tab and 1 short department tab is here: enter image description here

  • Related