Currently, I am using nested IF statements as shown below
=IF(ISNUMBER(SEARCH("Think",D2)),"Lenovo",
IF(ISNUMBER(SEARCH("Tough",D2)),"Panasonic",
IF(ISNUMBER(SEARCH("EVO",D2)),"HP",
IF(ISNUMBER(SEARCH("Mac",D2)),"Apple",
IF(ISNUMBER(SEARCH("Sun",D2)),"Oracle",
IF(ISNUMBER(SEARCH("Sparc",D2)),"Oracle",
IF(ISNUMBER(SEARCH("HP",D2)),"HP",
IF(ISNUMBER(SEARCH("Latitude",D2)),"Dell",
IF(ISNUMBER(SEARCH("Optiplex",D2)),"Dell",
IF(ISNUMBER(SEARCH("Proliant",D2)),"HP",
IF(ISNUMBER(SEARCH("Precision",D2)),"Dell",
IF(ISNUMBER(SEARCH("Wyse",D2)),"Dell",
IF(ISNUMBER(SEARCH("Alienware",D2)),"Dell",
IF(ISNUMBER(SEARCH("Aspire",D2)),"Acer",
IF(ISNUMBER(SEARCH("Dimension",D2)),"Dell",
IF(ISNUMBER(SEARCH("Gobook",D2)),"Itronix",
IF(ISNUMBER(SEARCH("GD6000",D2)),"Itronix",
IF(ISNUMBER(SEARCH("Inspiron",D2)),"Dell",
IF(ISNUMBER(SEARCH("Lifebook",D2)),"Fujitsu",
IF(ISNUMBER(SEARCH("Intellistation",D2)),"IBM",
IF(ISNUMBER(SEARCH("NetVista",D2)),"IBM",
"Unknown"))
)))))))))))))))))))
This gets too cumbersome after a while, also, I suspect its a drag on system resources. My file has over 80k rows
Bookmarks