Hi,
I am trying to do index match on same row is this possible?
EG:
<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
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