Tables, named ranges, line breaks, modern functions, and helper columns make Excel formulas easier to read, audit, and fix.

This is my simple way to use the VLOOKUP function in Excel to find data fast. I walk through how I use VLOOKUP to look up inventory amounts from a table. This helps me quickly check how many items we ...

Learn how to do a VLOOKUP in Excel and solve common VLOOKUP not working issues. Use simple steps and keep your spreadsheets error-free. VLOOKUP in Excel is one of the ...

An employee wonders what to do when they don't have enough to do. Getty Images/iStockphoto I’m working from home in a new job and, honestly, I don’t have enough to do. I’ve offered to help out my ...

The association of tables is a common task in work, and if you only think about using VLOOKUP, you are out. Although VLOOKUP can also solve many common problems of data lookup and referencing, it also ...

The VLOOKUP function in Excel is an incredibly powerful and versatile tool for data retrieval and analysis. It allows you to efficiently search for a specific value in one column of a table and return ...

Shadow work is the process of exploring the unconscious reasons behind your feelings or behaviors, particularly uncomfortable emotions that seem out of character or beyond your control. For example, ...

This is Work in Progress, a newsletter about work, technology, and how to solve some of America’s biggest problems. Sign up here. The paradox of the modern white-collar worker is that she is ...

The relationship between talent and effort is rather more complex than people think. Historically, there has been a tendency to regard both variables as independent, and talent is often defined as ...

The importance of building positive relationships at work is one of those things we know is important, but can often get lost in the daily hustle of over flowing to-do lists. Strong professional ...

When I’m working, I hyperfocus on the task at hand. If I’m writing an article—like this one, for example—I sit down at my desk around 8:30 a.m., conduct a couple of interviews, research the topic I’m ...

VLOOKUP, or Vertical Lookup, is a powerful function in Excel that allows you to search for specific data in a column and return a value from a different column in the same row. Here’s a concise guide ...