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.

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, 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.

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.

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?

HOW?

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?

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?