Index match same row?? possible?

[rsj88]

Hi,

I am trying to do index match on same row is this possible?



EG:

Apple	10/02/2018	car	12/03/2017
Orange	11/02/2018	bus	23/02/2018
Banana	12/02/2018	van	16/12/2018

<tbody>
</tbody>

I want to search the top row for "car" and when it finds it return the adjacent cell so "12/03/2018". The word car could be anywhere in row A1:Z1

 

[AlanY]

just +1 to the match result

 

[rsj88]

Doesnt work on the same row =INDEX(A2:D2,MATCH("Car",A2:D2,+1)) just returns car i need it to return 12/03/2017

 

[AlanY]

try this

=INDEX(A2:D2,MATCH("Car",A2:D2,0)+1))

 

[rsj88]

Thanks AlanY works prefect

 

[AlanY]

you're welcome