http://www.excelforum.com/showthread.php…314#post4513314
http://www.mrexcel.com/forum/excel-qu…-help-asap.html
Hi everyone, I have a problem that I hope someone can help me with. I have a list of postcodes in one sheet and these are assigned an area in the next column.
e.g. 2000 Sydney
2060 North Sydney
I then have another sheet of data with just postcodes (lots of them). I want to use the data from the first sheet to populate the adjacent column in the new sheet.
i.e. 2000 = some formula to look up the value in the column next to the postcode in the first spreadsheet
2060 = some formula to look up the value in the column next to the postcode in the first spreadsheet
The result being:
2000 Sydney
2060 North Sydney
How could i do this? Thank you!