Excel Tips - Tip 42 (Using Vlookup with match command)

Hello,

Hope my excel tips are helping you out.

Here is Today’s tip for you. Hope this help you.

If ever we want to find a particular outcome from a range, then we uses  “Vlookup with match command”

What Does It Do ?

This function first lookup the data from the range , then it satisfy the outcome and provide the outcome in respect of the lookup value.

How to use it ?

''=vlookup(lookup Values, table array, Match(lookup Values, table array))

For examples please check the below images

Hope the Tip is found interesting to you and the same is clear.

Looking forward for a feedback.

If any of your friend is also interested for the said excel Tips , then asked them to fill the form by clicking on the below mentioned link:

https://docs.google.com/forms/d/12T8v5XY0XlF9IhuCZPQpydd8hjCtrW7hZs9_GiOffIw/viewform?c=0&w&usp

If you have something that you want to share with the group, please write to excelms.tips@gmail.com

Thanks & Regards,

CA Mohit Bansal

Excel Enthusiast

+91-9045773456

Excel Tips - Tip 41 (Using Multiple if command with vlookup)

Hello,

Hope my excel tips are helping you out.

Here is Today’s tip for you. Hope this help you.

If ever we want to satisfy a criteria and want a outcome from particular range if it meets the mentioned criteria, then we uses  Multiple if command with Vlookup.

What Does It Do ?

This function first satisfy the criteria  , that we have put, if the criteria meets then it provide the value in respect of the range of data.

How to use it ?

'=IF(Range,crietria,[sum_range]),TRUE COMMAND '=vlookup(lookup Values, table array, col index number, [range lookup], FALSE COMMAND '=vlookup(lookup Values, table array, col index number, [range lookup]

For examples please check the below images

Hope the Tip is found interesting to you and the same is clear.

Looking forward for a feedback.

If any of your friend is also interested for the said excel Tips , then asked them to fill the form by clicking on the below mentioned link:

https://docs.google.com/forms/d/12T8v5XY0XlF9IhuCZPQpydd8hjCtrW7hZs9_GiOffIw/viewform?c=0&w&usp

If you have something that you want to share with the group, please write to excelms.tips@gmail.com

Thanks & Regards,

CA Mohit Bansal

Excel Enthusiast

+91-9045773456