Replace single recurring value with value from list

Hello! I'm a major coding newbie and recently had someone make a request that I can't fulfill. I know it's possible, but I don't have the knowhow to put it into action, so I was wondering if anyone here could help.

Basically we're working with a huge spreadsheet, 8 columns, 2000 rows, and there's a particular value (we'll say it's the word "NAME") that occurs multiple times in each row. We want that value to be replaced row by row with a different value from a list. So, for instance, on row 1 "NAME" would be replaced with "NAME_LOWERCASE", and then on row 2 with "NAME_UPPERCASE", and row 3 with "NAME_BACKWARD," etc. There are a total of 6 different values we need to replace the original 1, row by row through the entire sheet. Each instance of the original value in the row needs to be replaced with the same variable value from the list, through the entire sheet.

It's way outside my knowledge of code, but it feels like it should be simple. (Kind of driving me insane, like having a word on the tip of my tongue.) Any help would be appreciated!

To have a clearer picture, please post a sample of the workbook, maybe with about 50 rows, to see how is the "NAME" being repeated. Also provide the list of values to be replaced with. And on a separate worksheet with the desired results shown would be very helpful.

Hi Holger,

I believe what OP wants is very different. I am guessing he has "NAME" across several rows, and then repeats in a certain sequence.

e.g.

Please Login or Register  to view this content.

That's my understanding though, could be wrong. We'll see what OP says.