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