Forum Discussion
Vlookup with Text.Contains
Hey,
I have two tables. One with the budget line information and classification and another column with various texts.
I need to bring the ranking to this second table. I believe the way is using Vlookup and Text.Contains. But I don't know where to start.
Table 2
Text
blueredcar
5458 key
Table 1
Budget Line Classification
Car Vehicles
Utensil Key
i need this result
Table 3
Text Budgeting Line Classification
blueredcar car vehicles
5458 key utensil key
1 Reply
Are you matching blueredcar with car vehicles because blueredcar contains the word car? Similarily 5458 key gets matched with utensil key because both contain the word key.
Please provide your inputs for logic behind match so that right solution can be provided.
