Category «Excel»

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 …

Excel – The Learning Curve

Pre University After struggling for nearly 6 years trying to learn excel, I got my driver license. And hormones. And everything that comes with that. I graduated high school and began college – still with my love of science. And …