In this blog post I will demonstrate how to perform a vlookup when the lookup value is not located in the far left hand side of the data set (It is typically located on the far left hand side)
=VLOOKUP ( lookup value , table_array , col_index_num , [range_lookup] )
Consider the data set below:
Say we want to perform a Vlookup to find all the Contact Names which belong to the Commercial Property Type in column D and we want to use a Vlookup to do so.
One way of doing this is to cut and paste column d and place it before the first column. But there is also another method the do a Vlookup without needing to relocate the Lookup value field.
Here is the formula that will allow us to do so
Here is the final outcome after applying the formula