Monday 2 November 2015

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:


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


No comments:

Post a Comment