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.