# INDEX+MATCH

## Taking the new Dynamic Array formulas out for a spin

The new Dynamic Array formulas are now in Office 365 Excel!  I have been playing around with some of them namely FILTER, UNIQUE and SORT which are awesome! Excel MVPs have helped us all with a ton of videos and posts out there introducing these new functions.  Just Google Excel new Dynamic Array formulas and …

## Dynamic sum formula for summing between two dynamic columns

Here is a quick but really useful coffee break dynamic sum formula 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 want to give the user the flexibility to choose the 2 ‘From’ …

## Make Using Tables your New Year’s Resolution

Well it’s the Boxing Day holiday here in Aussieland 2017 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 of New Year’s Resolutions.   If you are not using Tables in Excel, this would …

## INDEX, What’s the big deal?

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 learn INDEX + MATCH combo – it’s powerful and nimble.  Actually I am going to …

## Transposing Data with INDEX / MATCH combo

Transposing Data with INDEX / MATCH combo what this all about? 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 columns namely Date and …

## Why I like INDEX / MATCH combo (and not VLOOKUP)

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 VLOOKUP which can only look right), you don’t have to have sorted data to lookup …