Repalce part of text

[radosvep]

Hi guys,

Can anyone help me how I can change part of text in a cell, for example

A1 :configure vlan port 1/1/5/1:1:32 protocol-group pppoe

using vlookup for matching of values, columns C and D

1/1/5/1 1/1/8/1
1/1/5/11 1/1/9/3

Results:
configure vlan port 1/1/8/1:1:32 protocol-group pppoe

Thank you in advance

 

[djo5003]

If the text is always constant:

=CONCATENATE("configure vlan port ",VLOOKUP(RIGHT(LEFT(A1,LEN(A1)-26),LEN(LEFT(A1,LEN(A1)-26))-20),$C$1:$D$2,2,FALSE),":1:32 protocol-group pppoe")

Or if relying on A1 for output:

=CONCATENATE(LEFT(A1,20),VLOOKUP(RIGHT(LEFT(A1,LEN(A1)-26),LEN(LEFT(A1,LEN(A1)-26))-20),$C$1:$D$2,2,FALSE),RIGHT(A1,26))

 

[radosvep]

This is what I need,
Thank you,

Regards