Vlookup in Excel

Hello all. Let’s look at one of most commonly used functions in excel – Vlookup. Vlookup function lookup for a specified data in a selected table / range and returns the match. Syntax =vlookup(lookup_value, table_array, col_index_num, [range_lookup]) There are certain conditions while using vlookup: Lookup value should always be the first column of the tableContinue reading “Vlookup in Excel”

Select dataset based on drop down value

Hello all. In this tutorial, let’s look at returning a complete data set based on selected string as drop down value. This tutorial can home handy when you want to pull standard set of metrics for different department in an org or if you want to pull meta-data about certain product’s sales numbers. Let’s workContinue reading “Select dataset based on drop down value”

Picture lookup in Excel

Hello All. In this tutorial, let’s see how to do a picture lookup in excel. Imagine a list of name and corresponding pictures. If you select a name, the appropriate picture should list (something similar to a Vlookup / Hlookup). In our example, we are working on the below example: First, we need to assignContinue reading “Picture lookup in Excel”