How to do 2 Way Lookup in Excel – One value to lookup with...
I can safely assume that almost everyone knows about LOOKUP formulas or precisely VLOOKUP. That is probably because sights and sounds of Excel don't...
Understanding Excel CHOOSE() function [Intro]
"Your life is what you choose it to be"
In essence whatever we give to life it returns the same. If we give peanuts, it...
Creating Currency Converter in Excel [How To]
In the world we live in where almost every country has its own distinct currency and value, we almost always feel a need to...
Excel Conditional VLOOKUP – Switching Between Multiple Lookup Ranges
We all love LOOKUP functions in Excel and the heart favourite is VLOOKUP. We are well introduced to VLOOKUP and have already seen VLOOKUP...
Excel Drop Down List using Data Validation and Excel Tables that updates dynamically –...
Excel drop down lists are one easy way to keep your data error free and other benefit it is that it automates data entry to...
Building a reference to specific Worksheet based on Cell value using Formula
Most of the time businesses are managed using specialized software but when it comes to a final touch in reporting the data is exported...
How Excel VLOOKUP Works: How to use it – Explanation with Example
While explaining LOOKUPs in my previous post, I explained how in daily life we apply lookup functions in different situations and to understand better...
How Excel LOOKUPs Work: Demystifying mighty functions with an example from past [1 of...
Functions to Excel is like Sense to Humans. Humans with absent sense are no better than crawlers walking on two legs, without functions Excel...