Match array of cells

[Caly]

Hi! I have an array of columns with information related to each header and then an array of cells with part numbers that correspond to the headers. I am trying to do a formula where it will look at the full array of headers and bring in the information associated to the cell on that row. Can this be done via INDEX MATCH? Or a VLOOKUP?

In the attachment there are many column headers that based on the row of data from the first down shows the amount for the row by the header name.

in a separate cell the name will appear and in the next cell to that I want to have a formula where it will look atcolumn headers together and based on the row of information for the SKU that is selected, it will show the amount for the fruit type.
Thank you!

 

[RAJESH NATH]

kindly share your sheet...

 

[Caly]

Hi thank you. Please see attached.

All the headers are coded and the last column is where I am looking to create a formula so it may be updated easily in the raw data portion.

 

[mikerickson]

If "Product" is in A2
Then in M3, put the formula

=INDEX($B$:$K3, 1, MATCH(L3,$B2:$K2,0))
or
=SUMIF($B2:$K2, M3, B3:K3)

 

[RAJESH NATH]

practice.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
2	Product	customer A	customer B	customer C	customer D	customer E	customer F	customer G	customer H	customer I	customer J	CUSTOMER SELECTED BY LINE	QTY CUSTOMER FOR SELECTED
3	1A	5	15	25	35	45	55	65	75	85	95	customer A	5
4	2A	7	136	265	394	523	652	781	910	1039	1168	customer A	7
5	3A	8	22	36	50	64	78	92	106	120	134	customer H	106
6	4A	9	16	23	30	37	44	51	58	65	72	customer C	23
7	5A	7	5	3	1	15	18	18	49	36	44	customer H	49
8	6A	5	53	101	149	197	245	293	341	389	437	customer E	197
9	7A	6	48	90	132	174	216	258	300	342	384	customer A	6
10	8A	4	58	112	166	220	274	328	382	436	490	customer F	274
11	9A	45	84	123	162	201	240	279	318	357	396	customer F	240
12	1B	15	48	81	114	147	180	213	246	279	312	customer A	15
13	2B	49	48	47	46	45	44	43	42	41	40	customer A	49
14	3B	22	58	94	130	166	202	238	274	310	346	customer C	94
Sheet4

Cell Formulas
Range	Formula
M3:M14	M3	=INDEX(B3:K3,MATCH(L3,$B$2:$K$2,))

 

[RAJESH NATH]

If "Product" is in A2
Then in M3, put the formula

=INDEX($B$:$K3, 1, MATCH(L3,$B2:$K2,0))
or
=SUMIF($B2:$K2, M3, B3:K3)

If I am correct..
In your index formula it returns only result of 1st row..

 

[Caly]

Thank you. I will try this.
Question - since L is the column indicating which customer is selected, using L plus the row number and not locking it should return the associated response on each row correct?

 

[RAJESH NATH]

Thank you. I will try this.
Question - since L is the column indicating which customer is selected, using L plus the row number and not locking it should return the associated response on each row correct?

yes.....