Change text to match that of a list of text

**Consty1** · 07-02-2013, 12:33 PM

The title's probably confusing, I'll try and explain. Cells A1:A33 contain the names of the home side for a football match and cells K1:K33 the away side. Cell W2:W17 lists all the teams but with added data (G1 to G4) to the ends of the team name. What I'm trying to do is run a macro to change all the team names in the A and K column to match the text in column W. So for example in A1 is the team name "Odd", by running a macro I'd like that to be replaced by "Odd G4" from column W. Likewise in K1 is the team name "Molde" which would be changed/replaced by "Molde G4" from column W.

I'm basically trying to run a macro to change/replace all team names in column A and K to the values in column W.

Not even sure if this is possible but thought it was worth a shot. Thanks for any replies in advance.

Sample 17.xlsx

**nilem** · 07-02-2013, 12:58 PM

Hi Consty,
try it

Please Login or Register  to view this content.

**Marcol** · 07-02-2013, 01:16 PM

You could also try this formula approach

Sort Column W ascending (A-Z)
Then in say Y1, drag/fill down

Formula:

Please Login or Register  to view this content.

Then copy the result and Paste Special > Values to A1

[EDIT]
You have Stromsgodset in Column A and Stromgodset G1 in Column W

**Consty1** · 07-02-2013, 02:18 PM

I just noticed I had a typo. Thank you both for your replies, I've used the macro this time around but it's handy to know this can be accomplished with a formula as well.