GROUP1 is in one cell; the others are together in another cell.

"Bob Phillips" escreveu:

Is the text such as

GROUP1 VS;VV;VJ;VL

all in one cell, or many cells?

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Barbara" wrote in message
...
Ok,
Let's see if my english will be fine enough... (LOL)

The groups will be defined perhaps in a new sheet:
Ex:
GROUP RESULT
----------------------------------
GROUP1 VS;VV;VJ;VL
GROUP2 VR;VX;VI
GROUP3 VA;VN
GROUP4 VO;VZ

So in my main sheet, when in column B Excel finds VL, it should return the
value GROUP1 in column A.

Hope that I was clear. Thanks,
Barbara



"Bob Phillips" escreveu:

How do you know which group the codes go in?

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Barbara" wrote in message
...
Hi,
I have a spreadsheet where one of the columns displays a code (ex: VA,
,
CN,
VF, VV,...)

I need to display in a new column the group of these codes.
ex:
VA+CN=Group1
VF= Group2
VV=Group3

Should anyone can give me a clue???
Thanks a lot,
Barbara