Hi all,

Need some help plz. I have a sheet with names in column B and codes in
column C. I want to search a range of cells in column C and return the name
in the adjacent column B if a certain code is entered into Column C. Hope I
am making sense. Example:

B C
John Doe AT-577
Jane Doe AT-598

I need to search column C for "AT-577" and have the result to be "John Doe".
This seems simple but I can't get it to work for the life of me. I have
Excel 2003. Any help is greatly appreciated. Thanks.

Ron