VLookup

Fetching the relevant value from a table or a range by row is made possible with VLOOKUP. For the benefit of all, let’s quickly describe VLOOKUP with the syntax given below. It returns one value from the first match in the same row. 

= VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

Almost everyone works with lots of data ranging from medium to high volume datasets, and extracting information from such a sheet can become easier, with little to advanced knowledge of excel. Excel is widely used to perform simple to complex data analysis. It is a great tool for generating meaningful & insightful reports for quick decision-making. So, out of hundreds of functions available in Excel, the chosen one for today’s article is the most common &  popular “VLOOKUP”.