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 firstname.lastname@example.org. Check out our website www.foetron.com to know about the services offered by us.