If you mean that B6 = "AC" and you want to search for that within column C
on Sheet two, and then return the corresponding value in column A, then:

=IF(ISERROR($B$4),"AC not
found",INDIRECT("Sheet2!A"&MATCH("AC",Sheet2!$C$1: $C$100,0)))

Keep in mind that there could be other ways to accomplish the same thing.
Also, it is best to specify a range rather than using the entire column. In
my suggestion, I've used rows 1 through 100. You can adjust that as
necessary. Based on your example, it seems that you are saying that "AC"
will only appear one time. If that is true, then the formula above should
work without issue. If there is more than one "AC" and you want something
other than the first occurance to be found, then the above formula will not
work.

If this is not what you want, please give details.

HTH,
Paul

--

"Vandy" wrote in message
...
thanks for the help, i need a little more help than I thought.

I need to search column C on sheet2 to find the 1 "AC" and then post the
corresponding name in column A to B4 in sheet 1. Thanks again for your
help.

"PCLIVE" wrote:

Try this in B4 on Sheet1:

=IF(Sheet2!B6="AC",Sheet2!A6,"")

HTH,
Paul

--

"Vandy" wrote in message
...
Can I make it do this? If, on sheet 2, b6= the letters AC, take the
name
in
a6 and post it in b4 on sheet 1? If so I need help with the formula.