Forum Discussion
Solved
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...
- thank you so much 🙂 🙂 this has worked 🙂
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
ive just managed to add the link 🙂 is https://1drv.ms/x/s!AvgGqr39r8WulWCilrG4FTaaQBLj?e=48Lek9
Thanks!
I created a more convenient lookup range; this allowed me to create an INDEX/MATCH/SEARCH formula.
See the attached version.
- thank you so much 🙂 🙂 this has worked 🙂
HansVogelaar im sorry if im doing something wrong. It wont allow me to add any attachment all it is giving is a url link etc. It will allow me to add photos so added the picture to show what its bringing up. Sorry.