Hello folks,

I run an online store with a huge selection of inventory. My inventory
is downloaded from my distributor into an excel csv file. I like to go
in a "pretty up" the entries to make it presentable to my shoppers. The
trick is that there is about 10,000 products with descriptions and the
works in this sheet.

What I'm wanting to be able to do is this. I want Excel to search a
column. Within this column are the descriptions of every product. I
want this search to find a particular word within these strings of
text. If the word is not found, then the result would be nothing. If
the word IS found, then I want Excel to do a vlookup on another column
to match that word and return a string of text which would be added to
the description.

Example:

I have 3000 knives within a spreadsheet. Within the descriptions of
these knives are the type of steel used in the knife. I want Excel to
find the name of the steel (i.e. "440C"). When and if found, I want it
to take that steel name and go to another section or sheet and do a
VLOOKUP (or whatever function is needed) and match that steel type.
Upon doing this, Excel would return the description of the steel which
is listed in this section or page and add it to the original
description of the knife.

Hopefully this makes sense. If anyone could help here, I would greatly
appreaciate it.

Cole


--
Cole


------------------------------------------------------------------------
Cole's Profile: http://www.excelforum.com/member.php...o&userid=36004
View this thread: http://www.excelforum.com/showthread...hreadid=557888