Need A Formula

[CARBOB]

Need a formula in Col E that will convert the digits in COL's B:D to S=1,4,7;C=0,6,8,9;O=2,3,5. The digits range from 0 to 9. All suggestions appreciated.

CASH3 MID 100GROUP COMBO SUMS WITH HORS.xlsx
	A	B	C	D	E
15	03/18/09	8	5	0	COC
16	03/17/09	2	1	8	OSC
17	03/16/09	0	7	7	OSS
HOR COMBOS

 

[Von Pookie]

An extremely horrible and complex way of doing things, but may help you get by until someone comes along with a better formula (and there HAS to be one out there, I just can't figure it out):

=LOOKUP(B1,{0,1,2,3,4,5,6,7,8,9},{"C","S","O","O","S","O","C","S","C","C"})&LOOKUP(C1,{0,1,2,3,4,5,6,7,8,9},{"C","S","O","O","S","O","C","S","C","C"})&LOOKUP(D1,{0,1,2,3,4,5,6,7,8,9},{"C","S","O","O","S","O","C","S","C","C"})

 

[LxQ]

I made a little table in A2:B11
0 C
1 S
2 O
3 O
4 S
5 O
6 C
7 S
8 C
9 C

then I used the following formula:
=VLOOKUP(C15,$A$2:$B$11,2)&VLOOKUP(D15,$A$2:$B$11,2)&VLOOKUP(E15,$A$2:$B$11,2)

 

[CARBOB]

Thanks, both of you did better than I could do!!!!