HLOOKUP, or lateral lookup, is a useful function in Microsoft Excel that allows you to pull data from a hlookup spreadsheet based on a known value in the first column. Basically, it’s like searching for a name in a phone book – you know the name (your lookup value), and… Read More