How do I display contents of an adjoining cell?

[Sue Smith]

Hello,

I need to search alphanumeric contents of column A with the contents of
column c. If a match is found, I want to display the contents of the
adjoining cell in column b.

Ex:
A B C E
e21f Smith 23f4 Miller
r42e Jones 43kf Not found
23f4 Miller e4hh Not found

I should get a result of Miller in col E.

I have an array setup using 'exact' which gives me a True or False answer.
Is there a way to have excel display the contents of the adjoining cell in
col b for all true results?

Any assistance would be appreciated.

Thank you

 

[Biff]

Hi!

I have an array setup using 'exact' which gives me a True or False answer.
Is there a way to have excel display the contents of the adjoining cell in
col b for all true results?

Not sure what that means but would these be considered a match?

23F4 and 23f4

Is that why you want "exact"?

In column E you can just use a Vlookup:

=IF(COUNTIF(A$1:A$100,C1),VLOOKUP(C1,A$1:A$100,2,0),"Not found")

Biff

 

[Biff]

Ooops!

Typo:

=IF(COUNTIF(A$1:A$100,C1),VLOOKUP(C1,A$1:A$100,2,0),"Not found")

Should be:

=IF(COUNTIF(A$1:A$100,C1),VLOOKUP(C1,A$1:B$100,2,0),"Not found")

Biff

 

[Sue Smith]

Hi Biff!
Thanks so much. It worked great and made my day a lot easier.

You have a wonderful weekend. =)

Sue