Hi Guys,

I'm really ordinary at excel so be nice!!

I have a spreadsheet that has a list of all suburbs in my state in column 1 with the corresponding postcodes in column 2. In column 3 I have organised the suburb names into regions that i got from a different list. Needless to say the suburbs/postcodes are not aligned. What I want is a formula for moving/copying the postcodes to a 4th column next to my new organisation of suburbs. I've tried IF functions but being quite hopeless I've had no luck. Basically I need to formula to say something like Column 4 = Column 2 when Column 3 = Column 1. Since they dont line up I need to search Column 1 until it does equal column 3. I want no blanks. Is this even possible?? Thanks in advance.

Crania