First cell on row to read text to return date value

[DanniB33]

Hi all,

Excel newbie needing help!

I want to be able to read the row value G4:T4 and only when the first cell reads Surplus to input the relevant date from Row 3 into F4. eg - David Smith surplus start is J4 but the value in J3 should be input to F4

Cheers!

[Gregb11]

Please read the yellow banner at the top of the page. Attach a sample sheet so we don't have to re-create your data.

[Gregb11]

But it could be something like this, but this formula was not entered into Excel so may have some formatting issues.

=index(G3:T3,match("Surplus",G4:T4,0))

[Sam Capricci]

without really seeing your workbook, just the snapshot, it looks like this should work for you...
=INDEX($E$3:$N$3,MATCH("surplus",G4:T4,0))
wherever you put the formula, just drag down to fill in for each person.

edited to correct range

[DanniB33]

Agh! My apologies - first time poster error. I will post a workbook in future.

The above formulas have worked beautifully - thank you both.