View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Supe Supe is offline
external usenet poster
 
Posts: 59
Default Change cells with same text

I have a template that I use that does a VLOOKUP against the item description
from the data I pull. Issue I'm running across is that I have several items
that have the exact same description so the VLOOKUP is pulling that data from
the first description it finds. My work around right now is to manually
change the description of the items that are currently sharing the same
description. There are several items that are this way so it is very time
consuming. Is there a quicker way to change the similar cells in my data?