How to search termination date

[XL GURU]

Hi,

I have employee information. In column A contain Employee name and from column b to column z contain date in the 1st row

[t]col-a[/t][t]col-b[/t][t]to[/t][t]col-z[/t]
[t]DATE[/t][t]1-Apr[/t][t]2-Apr[/t][t]and so on[/t]
[t]1[/t][t]xyz[/t][t]Present[/t]
[t]2[/t][t]abc[/t][t]Present[/t]
[t]3[/t][t]pqr[/t][t]
[t]4[/t][t]lmn[/t][t]
[t]5[/t][t]guru[/t][t]TER[/t]

If 5th row employee terminate on 1st Apr then i should write the word "TER" in the cell b5.

Now my question is -

If I write name of employee in the cell 'AB2' who has terminated then I want his termination date in the cell 'AC2'.

[XL GURU]

Hi,

I have employee information. In column A contain Employee name and from column b to column z contain date in the 1st row


If 5th row employee terminate on 2nd Apr then i should write the word "TER" in the cell C5.

Now my question is -

If I write name of employee in the cell 'F2' who has terminated then I want his termination date in the cell 'F5'.

[daddylonglegs]

For youe example then use the formula

=INDEX(B2:C2,MATCH("TER",INDEX(B4:C7,MATCH(F3,A4:A7,0),0),0))

[shg]

Threads merged.

[XL GURU]

Thank You