Forum Discussion

dipeshdhanak's avatar
dipeshdhanak
Copper Contributor
Nov 20, 2023

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...
Formulas and Functions
OliverScheurich's avatar
OliverScheurich
Gold Contributor

dipeshdhanak 

=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.

dipeshdhanak's avatar
dipeshdhanak
Copper Contributor
Nov 20, 2023
Thanks a lot.