Hi,

I need a simple formula in column b, that says; look at column A if a2=
"city" look down column for "county" and return info in cell, if not "city"
leave blank. I do not want to put in specific city names. I just need to
get the county info next to the city info.

Can excel look up only part of a word?

simple version
A B C D
city totals---- prattville alabama gross amount
County Total ---Autauga alabama gross amount
city totals --- fairhope alabama gross amount
City totals --- foley alabama gross amount
city totals----gulf shores alabama gross amount
County Total----Baldwin

need to see
City totals ---prattville autauga
County Total---Autauga
Cit totals---fairhope baldwin
city totals---foley baldwin
city totals---gulfshores baldwin
county total ---baldwin

Can you Help?

U¿ytkownik "taxmom" napisa³ w wiadomo¶ci
...
Hi,

I need a simple formula in column b, that says; look at column A if a2=
"city" look down column for "county" and return info in cell, if not
"city"
leave blank. I do not want to put in specific city names. I just need to
get the county info next to the city info.

Can excel look up only part of a word?

simple version
A B C
D
city totals---- prattville alabama gross amount
County Total ---Autauga alabama gross amount
city totals --- fairhope alabama gross amount
City totals --- foley alabama gross amount
city totals----gulf shores alabama gross amount
County Total----Baldwin

need to see
City totals ---prattville autauga
County Total---Autauga
Cit totals---fairhope baldwin
city totals---foley baldwin
city totals---gulfshores baldwin
county total ---baldwin

Can you Help?

try in b1
=if(find("City";A1;1);right(A2;len(A2)-find("---";A2;1)-2);"")

mcg

Thank you, However, I'm not doing something right. A message comes up
stating that there is an error in the formula. Should I be replacing the ---
with something?
or do I use the formula exactly as you provided?


"Gazeta" wrote:


U¿ytkownik "taxmom" napisa³ w wiadomo¶ci
...
Hi,

I need a simple formula in column b, that says; look at column A if a2=
"city" look down column for "county" and return info in cell, if not
"city"
leave blank. I do not want to put in specific city names. I just need to
get the county info next to the city info.

Can excel look up only part of a word?

simple version
A B C
D
city totals---- prattville alabama gross amount
County Total ---Autauga alabama gross amount
city totals --- fairhope alabama gross amount
City totals --- foley alabama gross amount
city totals----gulf shores alabama gross amount
County Total----Baldwin

need to see
City totals ---prattville autauga
County Total---Autauga
Cit totals---fairhope baldwin
city totals---foley baldwin
city totals---gulfshores baldwin
county total ---baldwin

Can you Help?

try in b1
=if(find("City";A1;1);right(A2;len(A2)-find("---";A2;1)-2);"")

mcg

You might try changing the semi-colons to commas.

The semi-colons are a European format.


Gord Dibben MS Excel MVP

On Tue, 8 Aug 2006 11:39:01 -0700, taxmom
wrote:

Thank you, However, I'm not doing something right. A message comes up
stating that there is an error in the formula. Should I be replacing the ---
with something?
or do I use the formula exactly as you provided?


"Gazeta" wrote:


U¿ytkownik "taxmom" napisa³ w wiadomo¶ci
...
Hi,

I need a simple formula in column b, that says; look at column A if a2=
"city" look down column for "county" and return info in cell, if not
"city"
leave blank. I do not want to put in specific city names. I just need to
get the county info next to the city info.

Can excel look up only part of a word?

simple version
A B C
D
city totals---- prattville alabama gross amount
County Total ---Autauga alabama gross amount
city totals --- fairhope alabama gross amount
City totals --- foley alabama gross amount
city totals----gulf shores alabama gross amount
County Total----Baldwin

need to see
City totals ---prattville autauga
County Total---Autauga
Cit totals---fairhope baldwin
city totals---foley baldwin
city totals---gulfshores baldwin
county total ---baldwin

Can you Help?

try in b1
=if(find("City";A1;1);right(A2;len(A2)-find("---";A2;1)-2);"")

mcg