Excel’s VLOOKUP() function is notorious for returning wrong results, but it’s not the function, it’s the way you’re using it! Excel’s VLOOKUP() function finds a matching value in a list. It’s one of Excel’s most popular and misunderstood functions. It’s possible to enter the correct formula and still get the wrong result but with just […]
Articles Tagged: Excel Formulas
Learn to use Vlookup in Excel
Vlookup is one of the most popular look up functions in Excel. When you need to extract data from a table based on a particular value, you can use Vlookup to do that.
Learn to use appropriate “Cell Reference” in Excel Formulas
Learn to use appropriate “Cell Reference” in Excel Formulas >> Relative Cell Reference ================= Cell Reference changes with formula being copied and pasted in other cells >> Default cell references in a spreadsheet are relative, which change when copied and pasted. eg; E8, E9, E10, etc >> Obsolete Cell Reference ================= Cell Reference does NOT […]
Combine Text in Cells (Concatenate)
Combine Text in Cells Here’s another little-known feature available in Excel that I bet you’ll find various uses for. It is the ability to combine text from multiple cells into one cell. I use it frequently for joining text when I receive a file that has first and last names in separate columns. This feature […]