Forum Discussion
Solved
Find substring and bring category
Hello, I would like to map the following situation: There is table 1 with categories based on store names and there is also table 2 with transactions I would like to bring the ...
=INDEX( Mapping[Mapping], MATCH( TRUE, ISNUMBER( SEARCH(Mapping[Partial Text], [@[Name/Description]]) ), 0 ) )
I see that I cant upload excels in here.
So I have table mapping :
and table transactions - where I want to bring the mapping with formulas, not manually. Buuut I do not have a common key, just partial text.
=INDEX( Mapping[Mapping],
MATCH( TRUE, ISNUMBER( SEARCH(Mapping[Partial Text], [@[Name/Description]]) ), 0 ) )- Thank you very much!
Frosty_Average , you are welcome