Hello,
I have attached a sample workbook.
I have input data in columns A:E.
I have a section for output data in columns K:P.
I would like a function that searches the string in K, for partial match in A.
Names in K will always have a prefix of a different length followed by an "_".
The inputs can be frequently updated (A:E), so the search needs to also take into account the fact that A might have inputs past row 6.
If the string in K is not found in A, I would like it to match to the "Default" input data.
Columns should match Left to Right (i.e: L should return B, M should return C, N should return D, O should return E).
I have tried very basic things using FIND and MATCH, but my excel ability is not this advanced!
Many Thanks!
Bookmarks