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 the pick up a particular item from a
group of range , then we uses “ LOOKUP” Command.
What Does It Do ?
·
This function looks for a particular information from a
list, and then picks an item from a second range of cells.
·
The What To Look For should be a single item.
·
The Range To Look in can be either horizontal or vertical.
·
The Range To Pick From must have the same number of cells in it
as the Range To Look in.
How to use it ?
''=LOOKUP(What To Look For ,Range To Look In ,Range To Pick
From)
For example, please check the 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