Hi dudes
i am new here so hello all!
i dont have so much experience with Excel so i need a lilttle help if possible
The problem is the following one:
In A1 i have a list with alot veicles description and that list has many brands lets say just some of them for now:
bmw, mercedes, fiat, peugeot, alfa romeo, lotus, ferrari but they are OVER 40.
Veicles descriptions can be like this:
* Special offer very good condition bmw 318 year 2002 color black
* In offer a new aston martin model x5 0km year 2010
* Good conditions fiat lancia 2.0 year 1990
* Second hand really crap mercedes from 80's
So i need a formula which search in the the colum A1 what kind of brand the veicle is (if contain ferrari, if contain fiat, if contain bmw) and then fetch the number from the corrisponding brand which is specified in Sheet2, if not found then i need some error to check manually and evenctually add to sheet2 the new brand and assign to him a new number never used before. The result must be placed on A2 and should be something like that:
A1 A2
Good conditions fiat lancia 2.0 year 1990 ------ 45 (45 because is the corrisponding number to lancia in sheet2)
Well it is impossible to me to check cell per cell what kind of veicle is inside then go back in the brand database check the corrispettive number and write it by hand, for some reasons i need a formula doing without using filters.
I have tried using if nested formulas but with over 40 brands doesnt works.
How can i do plix plox? sorry for my english i hope you understand something.
in attachment images for example, sorry for my english
Thank you
Bookmarks