Conditional 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 [...]

Multi Conditional lookup in Excel

Have you ever came across a situation wherein you wanted to return a value which matches both row and column?. Vlookup function in Excel returns the value which is matching the row only. In our previous tutorial, we have shown how to perform two column lookup. In this excel tips post, we will guide you [...]