Excel query

[colin5392]

What formula would have to be created in F2 to show that A2 (32) is found in column 2 (second table)? Or that 16 in B2, in the first table, is located in column 4 of the second table and so on...

Apologies - I can't get the XL2BB to work so having to show an image only

 

[dreid1011]

Minisheet:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	1	2	3	4	5							1	2	3	4	5	6
2	32	16	29	41	36							1	2	3	4	5	6
3	13	50	47	7	39							7	8	9	10	11	12
4	37	19	18	14	31							13	14	15	16	17	18
5	39	37	4	7	33							19	20	21	22	23	24
6	44	47	15	28	24							25	26	27	28	29	30
7	42	45	33	37	26							31	32	33	34	35	36
8	23	43	3	4	10							37	38	39	40	41	42
9	4	24	12	36	27							43	44	45	46	47	48
10	23	19	10	1	4							49	50
Sheet1

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	1	2	3	4	5							1	2	3	4	5	6
2	32	16	29	41	36	2	4	5	5	6		1	2	3	4	5	6
3	13	50	47	7	39	1	2	5	1	3		7	8	9	10	11	12
4	37	19	18	14	31	1	1	6	2	1		13	14	15	16	17	18
5	39	37	4	7	33	3	1	4	1	3		19	20	21	22	23	24
6	44	47	15	28	24	2	5	3	4	6		25	26	27	28	29	30
7	42	45	33	37	26	6	3	3	1	2		31	32	33	34	35	36
8	23	43	3	4	10	5	1	3	4	4		37	38	39	40	41	42
9	4	24	12	36	27	4	6	6	6	3		43	44	45	46	47	48
10	23	19	10	1	4	5	1	4	1	4		49	50
Data

Cell Formulas
Range	Formula
F2:J10	F2	=SUMPRODUCT(($L$2:$Q$10=A2)*($L$1:$Q$1))

 

[dreid1011]

Perhaps this:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	1	2	3	4	5							1	2	3	4	5	6
2	32	16	29	41	36	2	4	5	5	6		1	2	3	4	5	6
3	13	50	47	7	39							7	8	9	10	11	12
4	37	19	18	14	31							13	14	15	16	17	18
5	39	37	4	7	33							19	20	21	22	23	24
6	44	47	15	28	24							25	26	27	28	29	30
7	42	45	33	37	26							31	32	33	34	35	36
8	23	43	3	4	10							37	38	39	40	41	42
9	4	24	12	36	27							43	44	45	46	47	48
10	23	19	10	1	4							49	50
Sheet1

Cell Formulas
Range	Formula
F2:J2	F2	=SUMPRODUCT(--($L$2:$Q$10=A2)*(COLUMN($L$2:$Q$10)-11))

 

[colin5392]

=SUMPRODUCT(($L$2:$Q$10=A2)*($L$1:$Q$1))

Perfect thanks

 

[Fluff]

Glad we could help & thanks for the feedback.