VLOOKUP Vs. INDEX/MATCH - The Debate Ends Here
It's time to put the age old debate to an end. Is VLOOKUP the best lookup and reference formula in Excel? Or does INDEX-MATCH combo has an upper edge?| Trump Excel
It's time to put the age old debate to an end. Is VLOOKUP the best lookup and reference formula in Excel? Or does INDEX-MATCH combo has an upper edge?| Trump Excel
INDEX MATCH is a powerful combination that allows you to do simple and advanced lookups in Excel. In this article, I'll show you 10 examples of using this.| Trump Excel
VLOOKUP is the most popular Excel function. Here are 10 VLOOKUP Examples that will make you a VLOOKUP pro + a FREE VLOOKUP Ebook| Trump Excel
In this tutorial, learn how to use Excel MATCH Function. MATCH function looks for a value or string in a list and returns its position in that list| Trump Excel
In this tutorial, learn how to use Excel IF function. If Function is best suited when you want to test a condition and return a result based on it| Trump Excel
Conditional formatting in Excel highlights cells that meet a specified condition. Here is a guide on using conditional formatting in Excel.| Trump Excel
Use the steps in this tutorial to highlight every other row in Excel using conditional formatting. You can extend this to highlight every nth row/column.| Trump Excel
One area that often troubles Microsoft Excel users is working with dates.| Trump Excel
In this tutorial, you will how to quickly find and highlight blank cells in Excel. You can do this using conditional formatting, Go to Special, or VBA.| Trump Excel
Want to highlight rows based on a cell value? In this tutorial, I will show you how to use Conditional Formatting to highlight rows in different scenarios.| Trump Excel
Learn how to easily Compare two Excel sheets (in the same workbook or in different workbooks). You can compare sheets side by side or use formulas.| Trump Excel
