return value two cells left of value

[kylefoley76]

I'm trying to go down column a, look for a certain word, let's say 'excel', then return the value in the cell four cells to the right.

My best guest was

=offset(search("excel",a:a),0,4)

But the search function and the find function really aren't built for that.

 

[Son]

let's say you have the following, starting from range A1 with apple, and you need to get the value 8 in range G1, then you type in G1 =INDEX(E:E,MATCH("excel",A:A,0))

apple	1	3	s	6		8
orange	1	3	s	7
excel	5	6	7	8
apple	1	3	s	9
excel	1	3	s	10

<tbody>
</tbody>

but be careful, this formula will bring the value which corresponds only to the first appearance of "excel" in column A.

 

[kylefoley76]

thanks that did it.

 

[Son]

glad to be of assistance!