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

I put the names in C and the codes in B and put this in a cell:

=VLOOKUP("AT-577",B:C,2,FALSE)

This will look in column B for the value AT-577 and return the
corresponding value in column C.

Cheers,
Jason Lepack


Airfive wrote:
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

With AT-577 in F1, use the formula
=INDEX($B$1:$B$10,MATCH(F1,$C$1:$C$10,0))

"Airfive" wrote:

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