How do I display contents of an adjoining cell?
 

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

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

"Sue Smith" wrote in message
...
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

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

"Biff" wrote in message
...
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

"Sue Smith" wrote in message
...
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

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

You have a wonderful weekend. =)

Sue
"Biff" wrote in message
...
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

"Biff" wrote in message
...
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

"Sue Smith" wrote in message
...
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