I have an Excel spreadsheet that has 2 columns so far ...

Col A = suburb name in full
Col B = an abbreviated version of the suburb (this appears on the same row
as the full name that appears in Col A)

I now need to enter hundreds of abbreviated suburb names - multiple and in
no particular order (which will be entered into a new column - Col C)

Question: is there a way I can "ask" ... if Col C matches any in Col B (not
case-sensitive preferably), then insert Col A (full suburb) into a 4th (new)
column (Col D)?

I apologise, I know this is a little confusing, but I would appreciate any
advice/help - I have searched everywhere and can't seem to find an answer.

--
Sally M, Queensland, Australia