Index match same row?? possible?

[rsj88]

Hi,

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



EG:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Apple[/TD]
[TD]10/02/2018[/TD]
[TD]car[/TD]
[TD]12/03/2017[/TD]
[/TR]
[TR]
[TD]Orange[/TD]
[TD]11/02/2018[/TD]
[TD]bus[/TD]
[TD]23/02/2018[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]12/02/2018[/TD]
[TD]van[/TD]
[TD]16/12/2018[/TD]
[/TR]
</tbody>[/TABLE]


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