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

"Sue Smith" <srsmith@starpower.net> wrote in message
news:DYidnbEWCpps7a7eRVn-pw@rcn.net...
> 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]

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" <biffinpitt@comcast.net> wrote in message
news:eOwiGL$vFHA.3148@TK2MSFTNGP10.phx.gbl...
> 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" <srsmith@starpower.net> wrote in message
> news:DYidnbEWCpps7a7eRVn-pw@rcn.net...
>> 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
>>
>>
>>
>>
>>
>>
>
>

[Sue Smith]

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

You have a wonderful weekend. =)

Sue
"Biff" <biffinpitt@comcast.net> wrote in message
news:%237oE9P$vFHA.2076@TK2MSFTNGP14.phx.gbl...
> 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" <biffinpitt@comcast.net> wrote in message
> news:eOwiGL$vFHA.3148@TK2MSFTNGP10.phx.gbl...
>> 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" <srsmith@starpower.net> wrote in message
>> news:DYidnbEWCpps7a7eRVn-pw@rcn.net...
>>> 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
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>
>