Suburb and Post code

[Matthewcj1967]

Hi,
I am having issues with a spreadsheet how do I Vlook up formula, so when I enter suburb in one column the corresponding post code comes up automatic in 2 columns over?

Look forward to replys.

 

[texasalynn]

What is a "Suburb"?

 

[Akashwani]

Hi,

Welcome to MrExcel.

Is this what you want to do?...

Excel Workbook
	A	B	C
1	Postcode	Suburb	State
2	2850	AARONS PASS	NSW
3	6280	ABBA RIVER	WA
4	6280	ABBEY	WA
5	3737	ABBEYARD	VIC
6	4613	ABBEYWOOD	QLD
7	2176	ABBOTSBURY	NSW
8	2046	ABBOTSFORD	NSW
9	3067	ABBOTSFORD	VIC
10	4670	ABBOTSFORD	QLD
11	7315	ABBOTSHAM	TAS
12	8006	ABECKETT STREET	VIC
13	7112	ABELS BAY	TAS
14	4627	ABERCORN	QLD
15	2795	ABERCROMBIE	NSW
16	2795	ABERCROMBIE RIVER	NSW
17	2325	ABERDARE	NSW
18	2336	ABERDEEN	NSW
Sheet1

Excel Workbook
	A	B	C	D
1	Suburb	*	Postcode	State
2	ABBEYWOOD	*	4613	QLD
Sheet2

If you have duplicate Suburbs then you may want to try this instead....

Excel Workbook
	A	B	C	D
1	Suburb	*	Postcode	State
2	ABBOTSFORD	*	2046	NSW
3	*	*	3067	VIC
4	*	*	4670	QLD
Sheet2

The formulas in C2 & D2 need entering with ctrl shift enter NOT enter. You can then copy them down as far as is required.
I hope that helps.
By the way, if it's Australian postcodes you are working with, I have a Workbook with them all in, if you need it just PM me.

Good luck.

Ak