Microsoft Excel gets powerful XLOOKUP function

When people ask me what my favorite software of all time is, my answer is always Microsoft Excel. True, I am a proponent of both Linux and LibreOffice, but the fact is, nothing compares to Microsoft Office. If I have to do some serious data analysis and need to work with spreadsheets, I want real Excel. Can I get by with LibreOffice Calc? I mean, yes, but I'd rather not. When looking to tell stories with data, I often turn to the VLOOKUP function -- one of the most important and powerful tools found in Microsoft Excel. Believe it or… [Continue Reading]