Forum Discussion
Rachel1950
Sep 24, 2023Brass Contributor
Excel formula help needed please
Hi, I am new to Excel and have been asked to create a formula to return the post code region the order is going to. The city postcode is in column H on "data" worksheet. On "Postcode Info" tab t...
- Sep 24, 2023thank you so much 🙂 🙂 this has worked 🙂
HansVogelaar
Sep 24, 2023MVP
Thanks!
I created a more convenient lookup range; this allowed me to create an INDEX/MATCH/SEARCH formula.
See the attached version.
Rachel1950
Sep 24, 2023Brass Contributor
thank you so much 🙂 🙂 this has worked 🙂