ADDING POSTCODES AUTOMATICALLY
 

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.

ADDING POSTCODES AUTOMATICALLY
 

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.

ADDING POSTCODES AUTOMATICALLY
 

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.

ADDING POSTCODES AUTOMATICALLY
 

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?

wrote:
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.

ADDING POSTCODES AUTOMATICALLY
 

ADDING POSTCODES AUTOMATICALLY
 

HOW?

ADDING POSTCODES AUTOMATICALLY
 

Hi Eternal Cat,

YES, BUT HOW?

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

---
Regards,
Norman



"eternal_cat via OfficeKB.com" <u14645@uwe wrote in message
news:5575ee2e780e4@uwe...
wrote:
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?

ADDING POSTCODES AUTOMATICALLY
 

THANKS, I'LL LOOK AT THE SITE.

Norman Jones wrote:
Hi Eternal Cat,

YES, BUT HOW?

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

---
Regards,
Norman

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?