ADDING POSTCODES AUTOMATICALLY

[eternal_cat via OfficeKB.com]

HELLO

I WISH TO HAVE THE POSTCODE IN THE ADJACENT CELL TO THE RIGHT FILLED IN
AUTOMATICALLY WHEN I ENTER THE SUBURB/TOWN. IS THIS POSSIBLE? HOW DO I DO
THIS?

THANK YOU!

CAT.

 

[jayj0nes]

Assuming your source of zip codes is on another sheet of your workbook
(along with their corresponding city names), you could simply use a
VLOOKUP formula to find the corresponding post code.

 

[jayj0nes]

Assuming your source of zip codes is on another sheet of your workbook
(along with their corresponding city names), you could simply use a
VLOOKUP formula to find the corresponding post code.

 

[eternal_cat via OfficeKB.com]

YES, I CAN PUT IN THE POSTCODES AND CITY NAMES ON ANOTHER SHEET OF THE
WORKBOOK!
HOW DO I USE THE VLOOKUP FORMULA TO AUTOMATICALLY FILL IN POSTCODES?

 

[eternal_cat via OfficeKB.com]

Assuming your source of zip codes is on another sheet of your workbook
(along with their corresponding city names), you could simply use a
VLOOKUP formula to find the corresponding post code.

YES, BUT HOW?

 

[eternal_cat via OfficeKB.com]

HOW?

 

[Norman Jones]

Hi Eternal Cat,

YES, BUT HOW?

http://www.contextures.com/xlFunctions02.html

 

[eternal_cat via OfficeKB.com]

THANKS, I'LL LOOK AT THE SITE.

Hi Eternal Cat,