Protected: 7 Excel Skills you MUST have!
There is no excerpt because this is a protected post.
Also tagged Excel Formulas, excel help, Excel Tips-
Home
Pages
Blogroll
Excel Store
My Excel blogs
Excel Functions
Protected: Easier life? – The lazy Way to Become an Excel Expert
There is no excerpt because this is a protected post.
Also tagged Excel Formulas, Excel TipsHow to Build a VLOOKUP Exact Match Formula that doesn’t Fail
Answer yes to these set of questions when you write a VLOOKUP 0 (exact match). This way you will always build Reports in which you trust.
At the Backend (haystack)
Is the lookup index column located at the left?
Is the index column free of duplicates?
Is the index column free of weird characters? For example: ” for inches, [...]
Stop Wasting your Time Trying to Do Tasks that VLOOKUP Approximate Match doesn’t Support
VLOOKUP is a great tool but if you have used it for your daily reporting purposes you may have notice some shortcomings…
VLOOKUP 1 searches on a left index column. Why left? Database tables have the key column on the left so I assume they consider this in the design. (INDEX and MATCH allow you to [...]
Also tagged Excel Formulas, VLOOKUPHow to Build a VLOOKUP Approximate Match that doesn’t Fail
Answer yes to these set of questions when you write a VLOOKUP 1 (Approximate match). This way you will always build Reports in which you trust.
At the Backend (haystack)
Is the lookup index_column located at the left?
Is the index column free of duplicates?
Is the index column free of weird characters? For example: ” for inches, m [...]
Revisit VLOOKUP, You may Be Missing some Important Point
Explore Vlookup in a new way so you make sense of old arguments in a innovative and enlightening ways.
The fact is that humans VLOOKUP everyday! Excel users too!
The fact is that you search information day by day and every occasion to decide and take actions. I found very useful to make sense about this great [...]
Using VLOOKUP – How to Avoid #N/A by Getting Rid of Spaces in the Backend List
VLOOKUP is pure bites, it doesn’t know if a guy mistypes a text. When Using VLOOKUP, “Martha” is not the same as “Martha ”
What does this mean? When Using VLOOKUP, the matching must be absolute. That is, letter by letter (not case sensitive), space by space, character by character.
The fact is that Excel Lists [...]
Using Vlookup – How to Set the Argument “col_index_num” very Easily
Setting the number of the attribute column is the most annoying part of Using a VLOOKUP formula.
You get it visually on the go or visually before writing the formula?
Anyway, follow these tips to make this process easier…
Tip 1 – Add a row above field headers and write each column number (before writing the formula)
Insert a [...]
Also tagged Excel Formulas, VLOOKUPExcel SUMPRODUCT – What can this Excel Swiss Army Knife Do for Me?
At first glance, this function can only help you multiplying corresponding components in the given arrays, and returns the sum of those products.
You will be impressed once you know the potential of this not-so-known function.
Here is what you can additionally do with it…
Conditional Count single (COUNTIF)
Conditional Count multiple (COUNTIFS)
Conditional Sum single (SUMIF)
Conditional Sum multiple (SUMIFS)
Vlookup [...]
Understand SUMPRODUCT Function and Start Using It Right Now
Learning to use SUMPRODUCT is a great investment, SP is 7 functions in one; it is the Excel Swiss Army Knife.
Just to repeat Excel Help: SUMPRODUCT “Multiplies corresponding components in the given arrays, and returns the sum of those products”.
Syntax: SUMPRODUCT(array1,array2,array3, …)
Where:
Array1, array2, array3, … are 2 to 255 arrays whose components you [...]