Our Recommendation for You Search your Query, You can find easily. for example search by book name or course name or any other which is related to your education

Followers

Right to Left VLOOKUP

The formula for searching data located on the left side of the column that contains the condition

In this tutorial, I will show how we can search the data range for a particular condition to return a result from a column located on the left side of the column in which the condition.

Example 1 - Search data from the left side column

In the first example of a combination of the INDEX and MATCH functions, we can create a formula that very well may be replaced by a formula that uses the VLOOKUP function.

In the picture below you see the range of data and a condition that we search. The cell 'I2' is a condition, we searching the two columns.
The first column is the column where there is a condition (in our case it is the column 'F')
The second column is the column where there is a desired result (in our case it is the column 'C').

Left VLOOKUP with Index Match search

The formula in cell 'J2' in the image above is as follows:

=INDEX(C2:C9;MATCH(I2;F2:F9;0))
or
=INDEX(C2:C9,MATCH(I2,F2:F9,0))

MATCH function searches a condition and returns the number of the order from a range of data in the 'F2: F9' for the condition in the 'I2' and this is number five (5). Furthermore INDEX function has arguments for Row and Column, and in this case the function searches the fifth (5) row in the range of data 'C2:C9' and returns it as a result of which the data or value as in this case the 'apple'. So this formula is the result back from the left side the conditions. If you want to see how this combination of functions can return the result from the right side column/conditions then refer to the previous tutorial VLOOKUP.

Example 2 - VLOOKUP to the left in combination with the function Choose

VLOOKUP to the left

In this second example, I will show how we can use the CHOOSE function, which nest in the VLOOKUP function to return a result also from the left side of the column where there is a condition.
The condition of the cell 'I2'
The first column to search for a condition the column 'F' with a range of cells 'F2:F9'
The second column from which formula should return the result is a column 'C' with a range of cells 'C2:C9'.

VLOOKUP to the left

The formula in cell 'J2' in the image above is as follows:

=VLOOKUP(I2;CHOOSE({1\2};F2:F9;C2:C9);2;FALSE)
or
=VLOOKUP(I2;CHOOSE({1,2},F2:F9,C2:C9),2,FALSE)

Example formula is taken from the "author" of this fantastic formula, MyndaTreacy. This formula could give me a layman translate, Search a condition in column 'F' and returns the result in column 'C'.