Forum Discussion
VLOOKUP, ARRAY, ROW, COLUMN please help!!!
I need a formula that will search the item # from table 1 in table 2 and display the number for each individual category ("inca", "ineb", etc.) The lines that do not have sales I want it to display a...
Also, when "looking up" from a Pivot Table I'd recommend the attached approach since Pivot Table columns can change and formulas can pull through the wrong data without you even realising
You create 2 helper formulas (a column match and a row match. Then your INDEX formula just brings back the value from the cell with those coordinates.
This formula then still works correctly even if your Pivot table columns are re-ordered or new one is added / disappears or if a new column is inserted in column A of your Pivot Table sheet.