Conditional Formula
What I have is a spread sheet of information from a vendor about several
different products. One specific column holds a single cell with what is
usually a paragraph of information about the product represented in that row.
What I need to get out of each €śparagraph€ť are specific key bits of
information and having to go through each paragraph for a minimum of key
points just seems to take forever.
What I would like to do is set up a few extra columns.
For example:
A(acid free) B(lightfast) C(made in USA or Imported)
€¦have these columns look through the €śparagraph€ť and return either a €śY€ť or
€śN€ť for A & B and either €śUSA€ť or €ťI€ť for column C.
Any help would be greatly appreciated!
|