I need excel vba to search and replace based on certain conditions.
Replace entries in Column D as described below.
ORANGE with ORANGE SODA
GRAPE with GRAPE SODA
RED with RED SODA
then change all the entries that don't match ORANGE SODA, GRAPE SODA, and RED SODA in column D with SODA POP