How to match and assign a brand to text in excel

[banme]

Hi i have excel sheet with lot of data , in one cell i have cars name modal name and brand name in other cell i have brands name only .
look like this

<code>---------------------------------------
| Cell A      | Cell B |  Cell C      |        
|-------------------------------------|
| Gt-44rs-Ford|        |<code>Ferrari</code>       | 
|-------------------------------------|
|mercedes c63 |        |toyota        |
|-------------------------------------|
|Ferrari 458  |        |<code>audi   </code>       |
|-------------------------------------|
|<code>gt </code>audi  car |        |Ford          |
|-------------------------------------|
|toyota supra |        |mercedes benz |
|-------------------------------------|
</code>

i want "cell C" Values match with "Cell A" and in "Cell B " that brand name print. look like this

<code></code>
<code>---------------------------------------
| Cell A      | Cell B |  Cell C      |        
|-------------------------------------|
| Gt-44rs-Ford|<code>Ford </code>   |<code>Ferrari</code>       | 
|-------------------------------------|
|mercedes c63 |<code>mercedes</code>|toyota        |
|-------------------------------------|
|Ferrari 458  |<code><code>Ferrari</code></code> |<code>audi   </code>       |
|-------------------------------------|
|<code>gt </code>audi  car |<code><code>audi</code></code>    |Ford          |
|-------------------------------------|
|toyota supra |<code>toyota</code>  |mercedes benz |
|-------------------------------------|
</code>

 

[Scott T]

Re: How to match and assiagn barnd to text in excel

This will work for items that are identical will not work with Mercedes since it is Mercedes Bens in one list and Mercedes in the other. I suggest just using Mercedes

	A	B	C
1	GT-44rs-ford	Ford	Ferrari
2	Mercedes c63	Mercedes	Toyota
3	Ferrari 458	Ferrari	Audi
4	gt audi car	Audi	Ford
5	toyota supra	Toyota	Mercedes

<tbody>
</tbody>

In B1 and copy down

=LOOKUP(2^15,SEARCH($C$1:$C$5,A1),$C$1:$C$5)

 

[banme]

Re: How to match and assiagn barnd to text in excel

thanks , its work , just one thing more can we modifies this formula that if no brand name match then that assign to other cars . anyways this is such a helpful my lot of time save . thanks again .

 

[Scott T]

Re: How to match and assiagn barnd to text in excel

just one thing more can we modifies this formula that if no brand name match then that assign to other cars.

Not quite sure what you want.