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:

  1. Open an Excel file.
  2. Write the formula in the cell as "=VLOOKUP" or can select from formula function.
  3. 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.
  4. 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 or you can directly mail us at Check out our website to know about the services offered by us.