H
hatter
I just started a new job and my company already had a file with abou
16,000 records in it (called Products). This file contains all of th
parts numbers that they carry. In this file there is one column calle
"description". This cell contains the dimensions, color name and som
other information such as if the piece is flat or rounded. I hav
another file that has about 400 records and this file tells me "colo
name" as well as the "type" of stone that it is (called Stone_Type).
What I am trying to do is add a field to the Products file that wil
say stone type. Is there a way to have Excel search the "description
from Products for "color name" from Stone_Type and if it finds i
return "type"? As previously mentioned "description" contains thing
other than just the color name. To further complicate things there i
no consistency as to where in the cell the color name is (meaning
cannot extract just that data). Most of the color names are more tha
one work long.
If the "description" field matched "color name" I could just do
vlookup and return "type" but with there being other data in the fiel
I don't know what to do. I thought about putting each work in its ow
column and doing a whole bunch of vlookups but the problem with that i
that most of the names are more than one word long. What I am thinkin
about now is using the find function to look for the "color name" i
"description" and if it finds it then return the cell reference so tha
I can run a vlookup off of that. I think this will work but I don'
know how to make it search all of the "color name’s (A2:A400 i
Stone_Type).
Does anyone know how I could do this or know of a better way to g
about it? As stated above I have 16,000 record I have to do this to s
I am sure this will take a very long time to run but once it is done th
first time that is it and I can hard code the values so I do not reall
care how long it takes.
Thank you. I am not sure if I did a decent job explaining this i
there are any questions please ask and I will try to respond a.s.a.p
16,000 records in it (called Products). This file contains all of th
parts numbers that they carry. In this file there is one column calle
"description". This cell contains the dimensions, color name and som
other information such as if the piece is flat or rounded. I hav
another file that has about 400 records and this file tells me "colo
name" as well as the "type" of stone that it is (called Stone_Type).
What I am trying to do is add a field to the Products file that wil
say stone type. Is there a way to have Excel search the "description
from Products for "color name" from Stone_Type and if it finds i
return "type"? As previously mentioned "description" contains thing
other than just the color name. To further complicate things there i
no consistency as to where in the cell the color name is (meaning
cannot extract just that data). Most of the color names are more tha
one work long.
If the "description" field matched "color name" I could just do
vlookup and return "type" but with there being other data in the fiel
I don't know what to do. I thought about putting each work in its ow
column and doing a whole bunch of vlookups but the problem with that i
that most of the names are more than one word long. What I am thinkin
about now is using the find function to look for the "color name" i
"description" and if it finds it then return the cell reference so tha
I can run a vlookup off of that. I think this will work but I don'
know how to make it search all of the "color name’s (A2:A400 i
Stone_Type).
Does anyone know how I could do this or know of a better way to g
about it? As stated above I have 16,000 record I have to do this to s
I am sure this will take a very long time to run but once it is done th
first time that is it and I can hard code the values so I do not reall
care how long it takes.
Thank you. I am not sure if I did a decent job explaining this i
there are any questions please ask and I will try to respond a.s.a.p