[VLOOKUP explained] VLOOKUP formula in Excel with example | VLOOKUP example between two sheets
If you are usually work in MS-Excel and don’t know about VLOOKUP formula then you should know about it, which is one of the most important functions of Excel to find data in a table or range. The most important thing is that VLOOKUP formula also works between two sheets or another workbook, which makes a lot of our work easier.
In this video, we explained VLOOKUP formula step by step in a very simple way (with example). So watch this video till the end.
- Firstly select a cell.
- And just type =VLOOKUP
- Lookup_value (Unique value) = Then select the value to lookup.
- Type a comma (,)
- Table_array = Select the range or table to look for the value.
- Type a comma (,)
- Col_index_num = The number of the column where the lookup value is located.
- To find an exact match =Type 0 or false
to find an Approximate match= Type 1 or True - Finally press Enter.
1 Comment
pornlist · June 12, 2020 at 1:24 pm
Good blog!
Happy every day!