Tag: INDEX+MATCH

Here is a quick but really useful coffee break tip. I used this handy INDEX + MATCH based formula the other day and thought it was a good one to share… Say you have this typical accounting situation where you …

Dynamic sum formula for summing between two dynamic columns Read More »

Tagged with: ,

Well it’s the Boxing Day holiday here in Aussieland and one of our traditions is watching the Test Cricket in Melbourne that always starts on Boxing Day.  Fantastic stuff.  But also, this is the time of the year to think …

Make Using Tables your New Year’s Resolution Read More »

Tagged with: , , , , , ,

The big deal is the INDEX formula is simply AWESOME!  Put it together with MATCH and you have an even powerful formula which I call the INDEX + MATCH combo.  Any budding data analysts out there I urge you to …

INDEX, What’s the big deal? Read More »

Tagged with:

OK imagine this – you have done the right thing as a budding data analyst and created your sales data down the page so that you can take advantage of Pivot Tables which likes dimensions of data going across in …

Transposing Data with INDEX Read More »

Tagged with: , , , , , ,

Somewhere along the line I realised I was better off using what I call the INDEX / MATCH combo in nearly all lookup situations and not the ever popular VLOOKUP.  The INDEX /MATCH combo can look left and right (unlike …

Why I like INDEX / MATCH combo (and not VLOOKUP) Read More »

Tagged with: , , ,