hey guys - confused again - sorry....
i have managed to figure out (sort of) my "vlookup" problem i had the other day. now, i need to update it.
i want to search a column, for two things, for instance CJ and mirrors or JK and Bumpers
this is what i did for the other problem
=IF(COUNTIF(G2:G2,"*KJ*"),"98;","")
i looked for KJ and added an ID of 98; to the right of it. now, i was hoping to modify it so that it looks for KJ and mirrors or KJ and bumpers or KJ and floor mats so that i can assign it an id based on what i'm looking for. for instance, if it's a KJ mirror, it goes in the Lifestyles>Mirrors category which has an id of 406.
am i making sense here? i hope so!!
i have managed to figure out (sort of) my "vlookup" problem i had the other day. now, i need to update it.
i want to search a column, for two things, for instance CJ and mirrors or JK and Bumpers
this is what i did for the other problem
=IF(COUNTIF(G2:G2,"*KJ*"),"98;","")
i looked for KJ and added an ID of 98; to the right of it. now, i was hoping to modify it so that it looks for KJ and mirrors or KJ and bumpers or KJ and floor mats so that i can assign it an id based on what i'm looking for. for instance, if it's a KJ mirror, it goes in the Lifestyles>Mirrors category which has an id of 406.
am i making sense here? i hope so!!
