Tag: VLOOKUP

Make Using Tables your New Year’s Resolution

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

Tagged with: , , , , , ,

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

Tagged with: , , ,
Top