I have 500 rows of 6 digit numbers where I need to assigned a unique value based on first three digit of the number:
For example: 100000-199999 Assign value U023
200000-299999 Assign Value U220
300000-366999 Assign Value U222
367000-399999 Assign Value U367
670000-679999 Assign Value U 327
I can then just vlook up any value if they fall in the above table to get the value assign.
Here are the 6 digit value I have
<tbody>
</tbody><colgroup><col></colgroup>
For example: 100000-199999 Assign value U023
200000-299999 Assign Value U220
300000-366999 Assign Value U222
367000-399999 Assign Value U367
670000-679999 Assign Value U 327
I can then just vlook up any value if they fall in the above table to get the value assign.
Here are the 6 digit value I have
100187 |
100188 |
130140 |
130143 |
130164 |
130184 |
130327 |
130385 |
130386 |
130451 |
140268 |
367115 |
367140 |
367149 |
367194 |
367325 |
367362 |
367366 |
367373 |
367374 |
100188 |
130142 |
130370 |
130373 |
130376 |
130386 |
130387 |
130654 |
130663 |
210137 |
210161 |
210185 |
367362 |
367631 |
100112 |
100113 |
100116 |
100120 |
100131 |
100132 |
100133 |
100135 |
100137 |
100138 |
100139 |
100140 |
100141 |
100145 |
100161 |
100162 |
100163 |
100167 |
100168 |
100170 |
100171 |
100180 |
100181 |
100182 |
100183 |
100185 |
100186 |
100187 |
100188 |
100189 |
100265 |
100631 |
110265 |
110613 |
130137 |
130140 |
130142 |
130143 |
130148 |
130151 |
130152 |
130166 |
130168 |
130170 |
130178 |
130180 |
130184 |
130187 |
130192 |
130315 |
130316 |
130325 |
130326 |
130327 |
130350 |
130352 |
130353 |
130360 |
130361 |
130362 |
130365 |
130370 |
130371 |
130373 |
130374 |
130375 |
130376 |
130377 |
130378 |
130379 |
130381 |
130383 |
130385 |
130386 |
130387 |
130388 |
130398 |
130410 |
130420 |
130421 |
130422 |
130423 |
130427 |
130441 |
130444 |
130445 |
130446 |
130451 |
130452 |
130453 |
130456 |
130617 |
130618 |
130619 |
130620 |
130625 |
130627 |
130628 |
130630 |
130633 |
130634 |
130635 |
130654 |
130663 |
130681 |
140268 |
160610 |
160611 |
160613 |
160614 |
160616 |
160619 |
210112 |
210113 |
210120 |
210127 |
210128 |
210129 |
210132 |
210133 |
210137 |
210138 |
210139 |
210140 |
210141 |
210143 |
210144 |
210149 |
210150 |
210161 |
210162 |
210163 |
210180 |
210181 |
210182 |
210183 |
210184 |
210185 |
210188 |
210189 |
300170 |
367110 |
367115 |
367128 |
367137 |
367138 |
367140 |
367141 |
367144 |
367146 |
367149 |
367157 |
367158 |
367159 |
367162 |
367172 |
367173 |
367174 |
367175 |
367176 |
367179 |
367186 |
367187 |
367188 |
367189 |
367191 |
367194 |
367325 |
367361 |
367362 |
367363 |
367366 |
367367 |
367368 |
367372 |
367373 |
367374 |
367451 |
367616 |
367631 |
367650 |
100182 |
<tbody>
</tbody><colgroup><col></colgroup>