The concatenate function may not be as well known as other common Excel features such as IF and VLOOKUP, but it’s still effective, even though it performs a more simple function in nature. If you are ...

In Microsoft Excel, Concatenate is a text function, and its purpose is to combine two are more text strings into one string. The Concentrate function can improve the way your data is aligned in your ...

If you’ve spent much time in Excel, you’ll know the pain that comes with creating a large spreadsheet, only to realize it needs adjusting. Thankfully, though, this doesn’t always need to be ...

A combo box’s autocomplete feature linked to a lookup function creates a flexible search tool. When entering data in Microsoft Excel, an autocomplete feature attempts to help. You probably use this ...

If you want to know how to use VLOOKUP to pull the last match in Excel, we’ve got your back. VLOOKUP’s syntax only returns the first occurrence of the lookup value. However, if you have data where the ...

If you want to learn how range lookup with VLOOKUP works in Excel, you’ve come to the right place. Using the VLOOKUP function in Microsoft Excel helps us find information in large tables quickly and ...

Practice using functions to automate billing for an imaginary company. For this automation I used functions such as CONCATENATE, VLOOKUP, IFERROR, SUMIF. For example: "=CONCATENATE(IFERROR(VLOOKUP(A21 ...