If we are querying the corresponding name using the Employee ID, we can easily use the VLOOKUP function. But now, we are trying to look up the contents of column A using column B, which is a reverse ...

Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.