using if formula on page 2 to post answer on page 1
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.
|