Find One Of Several Values Within A Cell
Is there a method to perform the following function?:
I) Using a list of values (In my case, these are text. For the discussion,
lets assume they are colors in 3 place format, like BLK, BLU, BRN, GRN, GRY,
RED, WHT, etc.).
II) Look in a cell, and see if any of those values exist (NOTE: There will
never be more than one of these values within a cell).
III) If any one of these values is found within the cell, state which value
it is.
For example, the statement might look like this:
=IF(FIND({any of the values listed},E2,1),{whatever value it found in
E2},€ťSorry Charlie€ť) - where E2 is the €śWithin Text€ť location for the FIND
function.
I can accomplish this with nested IF functions, but this limits me to only
seven values.
|