Forum Discussion
Help with Data Columns
I have a column of Data with a partial postcode, and each one is assigned to a Sales officer. so e.g., CV, B, DY, WV are all assigned to Joe Bloggs for example. In another column I have full postco...
You haven't told us what the full postcodes look like, so I made some up. See the attached demo.
=INDEX($B$2:$B$5,MATCH(TRUE,ISNUMBER(SEARCH($A$2:$A$5,E2)),0))
An alternative could be this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.
Thanks a lot.