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 🙂
Rachel1950
Sep 24, 2023Brass Contributor
ive just managed to add the link 🙂 is https://1drv.ms/x/s!AvgGqr39r8WulWCilrG4FTaaQBLj?e=48Lek9
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.
- Rachel1950Sep 24, 2023Brass Contributorthank you so much 🙂 🙂 this has worked 🙂