You can do a lot in Microsoft Excel and Google Sheets, beyond the obvious spreadsheet-style organization and data collating. A lot of this is tied to both of their programming-like functions that ...

How to Use an Alphanumeric Mix in VLOOKUP Statements in Excel. Excel's VLOOKUP function searches cell arrays for data that you provide.

You can quickly look up text from your Excel spreadsheets from several online sources. For example, if there was a word or account name that you were not familiar with, you could simply have Excel ...

Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel.