Find certain value and Replace with certain comment

[bebebebebe123]

Hi,

I have a row with values, which range from 1 to 30,
and each number is corresponding to a certain comment, which is on another row. And some value cell have more than 1 value, (eg. 5,12) If it possible to replace them automatically?

I have tried formula but it failed miserably.

Can a VBA do this or simple stick to find and replace? Thanks!

 

[Sektor]

What do you want to replace with?

 

[bebebebebe123]

Hi,

I would like to replace a certain value with a certain comment, which is on another column.

Now it is something look like this:
ColumnA ____ColumnZ
1 _____________1 Poor
2 _____________2 Below Average
4,5___________ 3 Satisfactory
3 _____________4 Above Average
4 _____________5 Decent
5,6____________ 6 Good
6 ______________7 Excellent
On the on...

I would like a formula or vba can replace the value on column A to the comment on column Z.

Sorry for my English, it's kind of broken, thanks in advance!