Excel ? IF Statements, LOOKUPS & INDEX/MATCH. When to choose which one? – Part One.
- Comments Off
This article will focus on the appropriate use of IF statements, and also show you when it’s better to move into more robust formulas like LOOKUP, VLOOKUP, HLOOKUP & INDEX/MATCH. IF statements are one of the core formula models you can use in Excel, and they can be very powerful with regards to their […]
Free Excel Training
- Comments Off
Would you like to receive the same Microsoft Excel training that clients pay $250 an hour for, for free? No, really. Here are 10 free training videos on Microsoft Excel (See the links below). If your company was to hire us to do a webinar on Microsoft Excel formulas and functions, Pivot Tables, POWER Tips […]
Match Formula in Excel
- Comments Off
The Match Formula in Excel is an easy way to have excel look through an array of values and return the relative position if the match is found. The difference between this and the lookup functions (eg. Vlookup) is it return the position of the item and not the item itself. Let’s go ahead and […]