【EXCEL】輸入地址，自動帶入郵遞區號

<p style="margin: 1em 0px; padding: 0px; border: 0px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 1.1rem; line-height: 1.75rem; font-family: "Noto Sans TC", 微軟正黑體, sans-serif; vertical-align: baseline; color: rgb(52, 52, 52); letter-spacing: 1px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"> ⬛ 問題： 如何在EXCEL中做到，在EXCEL中輸入地址，另一個欄位自動帶入郵遞區號。

(adsbygoogle = window.adsbygoogle || []).push({});

<p style="margin: 1em 0px; padding: 0px; border: 0px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-weight: 400; font-stretch: inherit; font-size: 1.1rem; line-height: 1.75rem; font-family: "Noto Sans TC", 微軟正黑體, sans-serif; vertical-align: baseline; color: rgb(52, 52, 52); letter-spacing: 1px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"> ⬛ 回答：

郵遞區號將其整理在「郵遞區號」的工作頁

我們想做的是在「地址」欄位中輸入地址後，在「郵遞區號」欄位自動帶出上述的工作頁中的郵遞區號

我們只要在A2欄位輸入公式： =VLOOKUP(LEFT(B2,5)&"*",郵遞區號!A:B,2,0)

其它欄位用滑鼠拉公式，並將期填滿。

(adsbygoogle = window.adsbygoogle || []).push({}); <div style="margin: 45px 0px 0px; padding: 0px; border: 0px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-weight: 400; font-stretch: inherit; font-size: 16px; line-height: inherit; font-family: arial, "Century Gothic", 微軟正黑體; vertical-align: baseline; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; color: rgb(0, 0, 0); letter-spacing: 0.8px; background-color: rgb(255, 255, 255);"> <h2 class="ih-heading" style="margin: 0px 0px 15px; padding: 0px; border-width: 0px 0px 2px 2px; border-top-style: initial; border-right-style: initial; border-bottom-style: solid; border-left-style: initial; border-top-color: initial; border-right-color: initial; border-bottom-color: rgb(2, 141, 99); border-left-color: rgb(2, 141, 99); border-image: initial; font-style: inherit; font-variant: inherit; font-weight: normal; font-stretch: inherit; font-size: 18px; line-height: 1; font-family: inherit; vertical-align: baseline; letter-spacing: 0.7px; background-color: rgb(255, 255, 255);"> 延伸閱讀

<p style="margin: 1em 0px; padding: 0px; border: 0px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-weight: 400; font-stretch: inherit; font-size: 1.1rem; line-height: 1.75rem; font-family: "Noto Sans TC", 微軟正黑體, sans-serif; vertical-align: baseline; color: rgb(52, 52, 52); letter-spacing: 1px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"> ■ EXCEL 文書處理相關文章🔍

隨手記錄