## 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

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').

**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').

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

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'.

**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'.

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

or

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'.

**=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'.