# Need A Formula

#### CARBOB

##### Well-known Member
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
GHIJKLMNOPQRS
201431432O2132883
214214213E24-2-3773
224214212E24-2-3773
234234230E24-2-1992
VTRACS TRAILS FILTERS

### Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Is that what you were looking for?

Code:
``````=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)``````

PA HS Teacher said:
Is that what you were looking for?

Code:
``````=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

Replies
2
Views
195
Replies
18
Views
392
Replies
1
Views
102
Replies
5
Views
252
Replies
1
Views
67

1,206,921
Messages
6,075,590
Members
446,147
Latest member
homedecortips

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back