Hi,

I have in column F a cell (which is dynamic, between F8:F400) which has the text "01 Incident Number".

I need a formula which finds this text, gets the relevant text from the adjacent cell and then pastes that adjacent text in cell C4.

Any help please???

Thanks in advance.