Neptune’s Neighborhood

Neptune’s Neighborhood Fish-Keeping Back in 2012 I picked up the hobby of fish keeping. It’s something I thoroughly enjoy even though I don’t currently keep any fish; keeping fish is not an easy task. Between two moves I’ve lost a lot of space and have given up all but one of my aquariums. The only …

Index/Match

So, you want to look something up in a table better Grab a copy of this example workbook Last time, we explored the three main ways to look up values in tables to return corresponding data: lookup, vlookup and hlookup. As I said, “inevitably, =Index(Match) is always the best option.” If you’re anything like me, …

Lookup, VLookup & HLookup

So, you want to look something up in a table Grab a copy of this example workbook Excluding VBA, there are three main ways to look up values in tables to return corresponding data: lookup, vlookup and hlookup. So, let’s explore these and discuss why, inevitably, =Index(Match) is always the best option: Consider this “table” …