Need to pick out the date of an event from a table

[Roley]

In planning for next year the operations team will prepare a table with activity and the month they plan. Into a seperate ttable they will list items such as cost and time by staff member for each activity

They would like to adjust the month so as to balance time and the cost of each activity.

How do I reflect the month selected from the top table in the bottom table.

Activity		Jul 2017	Aug 2017	Sep 2017	Oct 2017	Nov 2017	Dec 2017	Jan 2018	Feb 2018
A			X
B					X
C		X
D				X
E							X
F			X
G						X
Activity	Date
C	???	What month is this planned for
A	???
B	???
E	???
G	???
F	???
D	???

<colgroup><col span="2"><col><col span="7"></colgroup><tbody>
</tbody>

Many thanks

Roley

 

[Tetra201]

Try this:

=LOOKUP("X",INDEX($C$2:$J$8,MATCH(A11,$A$2:$A$8,0),0),$C$1:$J$1)

 

[Roley]

Thank you very much. Solved my work problem

Now I have to work out why for my own satisfaction. Excel never ceases to amaze me

 

[Roley]

Thank you. On holiday in Thailand and can now relax