I"d like to use a vlookup function,that is part of macro, will return certain
values to the next column. Example, only Green and Red value is copied on
the column B from column A.


column A Column B
Green Green
Brown
Brown
Green Green
Red Red
Red Red
Black
Red Red

Wonder if anyone could help me.

Thanks,
Aline
--
Aline