## Find matching value in a row and return column name in Excel

When we work in excel sheets, we are required to find matching value in a row and return the Column name. For example, we need to calculate lowest priced store from the price table of multiple stores for multiple products. Another example can be finding the primary reason for exits from the exit feedback form [...]

## Creating conditional drop down list in Excel

In my earlier post, I have shown you how to create a simple drop down list in Excel. But meets most of our day to day requirements. However, when we create a dashboard or a template, we need to dependent drop down list or a conditional drop down list in Excel. That is based on [...]

## Excel Tip To Calculate The Number of Work Days Between Two Dates

There are many situation where we need to calculate the difference between two dates. We can get the no of days by subtracting the one date by one date. However, that gives the total days between these dates in which includes weekly offs and Holidays. To overcome this, excel provides a dedicated function called NETWORKDAYS.The [...]

## Formula to Format Cell in Excel Tips

In excel, we can format the numbers into different formats using the Format option. But sometimes we need to format the number which is a result of another formula. To do this, we can use TEXT formula.  Using this you can format date, time, numbers currency etc. So in this tutorial, we will see how [...]

## Excel If Function – Syntax And Examples

Excel IF function is one of my favorite function in Excel. It is very useful and very simple to use. It does wonders when you want to create some complicated excel Formulas. You can extend the functionalities of IF function by nesting it or using along with other Excel Functions such as VLOOKUP, AND, OR [...]

## Excel Vlookup Formula with IF Function-Condition Based vlookup

I have already written on basic vlookup function and conditional vlookup function. In this Excel tutor, i will show you how you can use vlookup function along with IF function. Recently i came across a situation where i need to use different vlookup formula when there is a different scenarios. So i thought even this [...]