Excel formula help for range

[sasa26feb]

Position	Location 1	Location 2	Location 3	Location 4	Location 5	Location 6
1	1	11	21	31	41	51
2	2	12	22	32	42	52
3	3	13	23	33	43	53
4	4	14	24	34	44	54
5	5	15	25	35	45	55
6	6	16	26	36	46	56
7	7	17	27	37	47	57
8	8	18	28	38	48	58
9	9	19	29	39	49	59
10	10	20	30	40	50	60

I am trying to select a Position '1' if Location selected are in the range of (1,11,21,31,41,51), and same for other Position nos, I have used IF(OR(J15 = {1,11,21,31,41,51}),A15) function but in that range no is fixed. Can anyone help. What if I don't want to give range value manually.

 

[KRice]

Are your location values in sequence as shown? If so, notice that on each row under the locations, if you divide each value by 10 and take the remainder, you'll get the position number...except for position 10, so we can make a small adjustment using the MOD function:
=MOD(C11-1,10)+1
...where C11 is one of the location values
will produce the Position number.