VLOOKUP Changed My Life

'Numbers Grid in NY' by By Procsilas Moscas https://www.flickr.com/photos/47207654@N00/11314489

After my post about postcodes earlier this week, a couple of people asked me what a ‘lookup table’ was in that context. I thought I’d write something quick about their use in the context of spreadsheets, because they’re such a timesaver.

You can probably divide the world into people who have no idea about VLOOKUP tables in spreadsheets, and those who use them every day. Until recently I was firmly in the former category, but now I’m part of the latter group. Continue reading “VLOOKUP Changed My Life”