Spreadsheet: 191652d1352171516-determine-if-a-value-occurs-within-a-set-of-values-and-ranges-help_please
Sheet: Option 1

Line1 | Line2 | [NAME] | Line4 | Line5
0001-4821,4899-5309,5312-5410,5733-5941,7011,5943,6514-7398,6013-6512 | 5722,5731,7400-7511,7513-9999,5412-5510,5512-5718,5945-5964,5966-5999
0763,4011,4111,4112,4131,4215,4411,4723,4816,4899,5044,5111,5169,5172,5199 | 5200,5211,5231,5251,5261,5300,5310,5411,5532,5551,5561,5599,5712,5732,5734 | 5811,5813,5942-5944,5946,5960,5962,5964,5965,5968,5970,5971,5983,5992,5999 | 6051,7221,7296,7299,7321,7379,7393,7512,7513,7531,7535,7538,7542 | 7549,7622,7629,7641,7829,7993,8021,8043,8071,8099,8111,9311,9399,6513
0742,4468,4789,5072,5094,5137,5309,5311,5331,5399,5422,5441,5462,5499,5511 | 5521,5533,5571,5598,5611,5621,5631,5641,5651,5655,5661,5691,5697,5699,5713 | 5714,5719,5722,5733,5735,5912,5921,5931,5932,5935,5940,5941,5945,5947,5948 | 5949,5950,5967,5977,5993-5996,6300,7012,7032,7210,7211,7216,7230,7298,5965 | 7333,7534,7623,7832,7841,7929,7933,7994,8042,8351,8675,9752,7033,8041,7261
0780,1520,1711,1731,1740,1761,1771,1799,2741,2791,2842,4214,4225,4457,4511 | 4722,4900,5013,5021,5039,5045-5047,5051,5065,5074,5085,5099,5122,5131,5192 | 5193,5966,5969,5998,7011,7278,7311,7338,7342,7349,7361,7372,7375,7392,7394 | 7395,7399,7692,7922,7941,7991,7992,7996-7999,8011,8062,8211,8220,8241,8244 | 8249,8299,8398,8641,8651,8661,8699,8734,8911,8931,8999
6010-6012,4829,6051
0001-4821,4899-5309,5312-5410,5733-5941,7011,5943,6514-7398,6013-6512 | 5722,5731,7400-7511,7513-9999,5412-5510,5512-5718,5945-5964,5966-5999
0763,4011,4111,4112,4131,4215,4411,4723,4816,4899,5044,5111,5169,5172,5199 | 5200,5211,5231,5251,5261,5300,5310,5411,5532,5551,5561,5599,5712,5732,5734 | 5811,5813,5942-5944,5946,5960,5962,5964,5965,5968,5970,5971,5983,5992,5999 | 6051,7221,7296,7299,7321,7379,7393,7512,7513,7531,7535,7538,7542 | 7549,7622,7629,7641,7829,7993,8021,8043,8071,8099,8111,9311,9399,6513
0742,4468,4789,5072,5094,5137,5309,5311,5331,5399,5422,5441,5462,5499,5511 | 5521,5533,5571,5598,5611,5621,5631,5641,5651,5655,5661,5691,5697,5699,5713 | 5714,5719,5722,5733,5735,5912,5921,5931,5932,5935,5940,5941,5945,5947,5948 | 5949,5950,5967,5977,5993-5996,6300,7012,7032,7210,7211,7216,7230,7298,5965 | 7333,7534,7623,7832,7841,7929,7933,7994,8042,8351,8675,9752,7033,8041,7261
0780,1520,1711,1731,1740,1761,1771,1799,2741,2791,2842,4214,4225,4457,4511 | 4722,4900,5013,5021,5039,5045-5047,5051,5065,5074,5085,5099,5122,5131,5192 | 5193,5966,5969,5998,7011,7278,7311,7338,7342,7349,7361,7372,7375,7392,7394 | 7395,7399,7692,7922,7941,7991,7992,7996-7999,8011,8062,8211,8220,8241,8244 | 8249,8299,8398,8641,8651,8661,8699,8734,8911,8931,8999
6010-6012,4829,6051
0001-4821,4899-5309,5312-5410,5733-5941,7011,5943,6514-7398,6013-6512 | 5722,5731,7400-7511,7513-9999,5412-5510,5512-5718,5945-5964,5966-5999
0763,4011,4111,4112,4131,4215,4411,4723,4816,4899,5044,5111,5169,5172,5199 | 5200,5211,5231,5251,5261,5300,5310,5411,5532,5551,5561,5599,5712,5732,5734 | 5811,5813,5942-5944,5946,5960,5962,5964,5965,5968,5970,5971,5983,5992,5999 | 6051,7221,7296,7299,7321,7379,7393,7512,7513,7531,7535,7538,7542 | 7549,7622,7629,7641,7829,7993,8021,8043,8071,8099,8111,9311,9399,6513
0742,4468,4789,5072,5094,5137,5309,5311,5331,5399,5422,5441,5462,5499,5511 | 5521,5533,5571,5598,5611,5621,5631,5641,5651,5655,5661,5691,5697,5699,5713 | 5714,5719,5722,5733,5735,5912,5921,5931,5932,5935,5940,5941,5945,5947,5948 | 5949,5950,5967,5977,5993-5996,6300,7012,7032,7210,7211,7216,7230,7298,5965 | 7333,7534,7623,7832,7841,7929,7933,7994,8042,8351,8675,9752,7033,8041,7261
0780,1520,1711,1731,1740,1761,1771,1799,2741,2791,2842,4214,4225,4457,4511 | 4722,4900,5013,5021,5039,5045-5047,5051,5065,5074,5085,5099,5122,5131,5192 | 5193,5966,5969,5998,7011,7278,7311,7338,7342,7349,7361,7372,7375,7392,7394 | 7395,7399,7692,7922,7941,7991,7992,7996-7999,8011,8062,8211,8220,8241,8244 | 8249,8299,8398,8641,8651,8661,8699,8734,8911,8931,8999
LOOKING FOR VALUES:
6010, 6011, 6012, 6050, 6051, 4829
4829
6010
6011
6012
6050
6051