Thanks for the reply

Can you please help me more on this.... as follow


if i have the data like

in cell k have three values and cell l one value how can call cell l value to all cell k values

"<opt mfr=""09021"" pnv=""RK73H2HL **4991F""/>
<opt mfr=""09021""pnv=CRCW20104K99FKTF""/>"

also i have the values in cell K sometimes more than one, in this case will take cell l value