Need A Formula

[CARBOB]

Using the 3 digit number in Col's G20:I20 and the criteria below , I need a formula in S20 that will return correct pattern. Thanks for your help.

Carbob


The L-CL-C-CH-H Pattern Filter


L=Low --> digits 0 and 1

CL=Center Low --> digits 2 and 3

C=Center --> digits 4 and 5

CH=CenterHigh ---> digits 6 and 7

H=High --> digits 8 and 9

eg. result 143 will have the pattern L-C-CL; 567 C-CH-CH ETC

CASH 3 VTRACS POWER TRAILS ALL POS.xls
	G	H	I	J	K	L	M	N	O	P	Q	R	S
20	1	4	3	143	2	O2	1	3	2	8	8	3
21	4	2	1	421	3	E2	4	-2	-3	7	7	3
22	4	2	1	421	2	E2	4	-2	-3	7	7	3
23	4	2	3	423	0	E2	4	-2	-1	9	9	2
VTRACS TRAILS FILTERS

 

[PA HS Teacher]

Is that what you were looking for?

=VLOOKUP(G20,{0,"L";2,"CL";4,"C";6,"CH";8,"H"},2,1) & "-" &
 VLOOKUP(H20,{0,"L";2,"CL";4,"C";6,"CH";8,"H"},2,1) & "-" &
 VLOOKUP(I20,{0,"L";2,"CL";4,"C";6,"CH";8,"H"},2,1)

 

[CARBOB]

Is that what you were looking for?

=VLOOKUP(G20,{0,"L";2,"CL";4,"C";6,"CH";8,"H"},2,1) & "-" &
 VLOOKUP(H20,{0,"L";2,"CL";4,"C";6,"CH";8,"H"},2,1) & "-" &
 VLOOKUP(I20,{0,"L";2,"CL";4,"C";6,"CH";8,"H"},2,1)

That works, Thank you