one way. copy down
=INDEX(2:2,0,MATCH("zzz",A2:F2))


On Nov 30, 6:00*am, Carpe Diem wrote:
Hi,

I have the following data in a sheet :

A * * * B * * * C * * * D * * * E * * * F
iglo * *iol
iglo * * * * * *sapo
iglo * * * * * * * * * *aeiou
iglo * * * * * * * * * * * * * *mf
iglo * * * * * * * * * * * * * * * * * *af

I would like to put in "G" (for each row) column the text between
Column B and Column C.

Example G2 = IOL, G3= Sapo. *There is only a value for each row

Thanks in advance