This video with a simple example can help you to organize your data in excel in a more efficient manner. The common issue finding the right information matching cell-wise value is resolved in this video using VLOOKUP function of Mcrosoft Excel.
To use VLOOKUP in excel follows these steps:
- Open an Excel file.
- Write the formula in the cell as "=VLOOKUP" or can select from formula function.
- A pop-up window will open, here Lookup_value defines a name for which you want to search your data, Table_array defines the entire sheet, Col_index_num defines from which column you want to search data and Range_lookup might be either TRUE or FALSE, where TRUE gives you closest value and FALSE gives you an exact value.
- Click on OK.
For any other concerns related to Office 365 plan and subscriptions. You can reach out to us by submitting a ticket on our portal https://cloud.foetron.com/ or you can directly mail us at [email protected]. Check out our website www.foetron.com to know about the services offered by us.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article