Yes, the letters "AC" only appears once per column. I also had an inquiry
in the worksheet functions area and Roger Govier sent a suggestion that
worked. Thank you so much for your time. I am interested if you have
another approach if you have the time to send it. I won't be able to respond
after today for a week or so, thanks again for your help.
"TomPl" wrote:

The formula could be copied to more columns. Do the letters "AC" appear only
one time on sheet 2 Column C?

"Vandy" wrote:

Could it be copied to the remaining columns -D thru AD?

"TomPl" wrote:

Is it feasable to move column "C" on sheet 2 to the left so it is in front of
columns "A", "B" etc. If so, a simple vlookup would do the job just fine.

"Vandy" wrote:

Sorry about the confusion, a nursing instructor here at school needs the
answer and I am trying to help. He has 2 sheets he is trying to get the data
to work with.
On sheet 2 he needs the name of the person in column A that is assigned the
letters "AC" in column C to appear on sheet 1 in column B6. We will then
need to copy the formula to column D, E, F, etc.

Thank you for your time and patience, you have been most helpful.