I love the adding a helper column to the lookup table. This is an awesome solution! It is great to be on our Online Excel team with you!!!!
@excelisfun
7 жыл бұрын
You should post a link to this video below the one I made, cuz adding a helper column to the lookup table is useful!!!
@XLarium
7 жыл бұрын
A good rule for helper columns is: If a part of the formula is repeating then you could/should use it in a helper column. It only has to calculate once and the formula gets significantly smaller.
@MySpreadsheetLab
7 жыл бұрын
I completely agree! Helpers are great! Easier to explain the solution and usually much lighter!
@vikramraghuwanshi9455
3 жыл бұрын
extra ordianry expanition done by you. on xlookup's .
Пікірлер: 5