Unsure if there's a formula/function that can do this

[Guest]

I would really appreciate any advice please ....

I have an Excel spreadsheet that currently has 2 columns ...

Column A = suburb name in full (eg Tewantin)
Column B = abbreviated version of suburb name eg Tewnt (note, this appears
in the same row as the full suburb name in Col A)

I now need to enter in a new Column (Column C) of abreviated suburbs
(multiple and not in the same order as those that appear in Columns A & B)

Question: After I have finished entering all the info in Col C, I would
like to 'ask' ... if Col C matches Col B, then insert Col A (suburb name in
full) into a new column (Col D). I'm sorry, I know this is a little
convoluted, but I hope someone can help me please.

 

[DL]

You should be posting to an Excel newsgroup, not an winxp ng

 

[Brian G]

I would really appreciate any advice please ....

I have an Excel spreadsheet that currently has 2 columns ...

Column A = suburb name in full (eg Tewantin)
Column B = abbreviated version of suburb name eg Tewnt (note, this
appears in the same row as the full suburb name in Col A)

I now need to enter in a new Column (Column C) of abreviated suburbs
(multiple and not in the same order as those that appear in Columns A
& B)

Question: After I have finished entering all the info in Col C, I
would like to 'ask' ... if Col C matches Col B, then insert Col A
(suburb name in full) into a new column (Col D). I'm sorry, I know
this is a little convoluted, but I hope someone can help me please.

Sally,

Try these groups msnews.microsoft.com for the information you require.

Brian G

 

[Guest]

Into the D1 cell, type:

=IF(B1=C1,A1,)