On Mon, 1 Nov 2004 01:05:00 -0600, Ronl
wrote:


HI,

I need to be able to check cell contents in a specific row (c) and see
if the text matches and if it does the put different text in a
different cell.

eg if a3="text" then a5="different text"

the information in a3 could be up to 15 different items resulting in up
to 6 different texts.

something like search and replace only replacing to a different
multiple cells 1 or 2 cells away, throughout the worksheet.

Is this possible?

Sounds like a job for a lookup table. Check HELP for VLOOKUP.


--ron