Hi there,
I tried lot to fix this. But I couldn't make it up. Kindly guide me in this.
I have keywords with few strings. I need to get those words too by vlookup.
For example:
Table: 1 (Reference sheet)
<tbody>
</tbody>
Table: 2 (My question)
<tbody>
</tbody>
Table: 3 (outcome)
<tbody>
</tbody>
Here, already I have Table 1 with ~ 20000 keywords. I have “Table 2” to be filled like “Table 3”. I will have maximum of two strings. One is “ | “ and next is “ ; ”.
For single keyword, I know we can directly apply Vlookup. But this case of stings how can we proceed further?
Hope I have explained my requirement clearly. Kindly let me know if you have any further questions.
My extreme thanks in advance.
Gopal
I tried lot to fix this. But I couldn't make it up. Kindly guide me in this.
I have keywords with few strings. I need to get those words too by vlookup.
For example:
Table: 1 (Reference sheet)
Apple | Fruit |
Orange | Fruit |
Ladies finger | Vegetable |
Carrot | Vegetable |
Banana | Fruit |
Jasmin | Flower |
<tbody>
</tbody>
Table: 2 (My question)
Apple | Orange | Banana | |
Apple | Jasmine | |
Carrot | |
Apple | |
Ladies finger; Orange |
<tbody>
</tbody>
Table: 3 (outcome)
Apple | Orange | Banana | Fruits & Fruits & Fruits |
Apple | Jasmine | Fruits & Flower |
Carrot | Vegetable |
Apple | Fruit |
Ladies finger; Orange | Vegetable & Fruit |
<tbody>
</tbody>
Here, already I have Table 1 with ~ 20000 keywords. I have “Table 2” to be filled like “Table 3”. I will have maximum of two strings. One is “ | “ and next is “ ; ”.
For single keyword, I know we can directly apply Vlookup. But this case of stings how can we proceed further?
Hope I have explained my requirement clearly. Kindly let me know if you have any further questions.
My extreme thanks in advance.
Gopal
Last edited: