Sumif, Index, Match formula not pulling in right results

[KRE]

I'm looking at the Price/Per formula that is returning $213.05 instead of pulling $594.64. Note the Contract Quantity Totals pulls 68.06 correctly using the same methodolgy?

Billing Values Table Below

 

[StephenCrump]

It's a little hard to tell from a picture, but try changing:

MATCH(B$4,'Billing Values'!$F$3:$W$3)

to:

=MATCH(B$4,'Billing Values'!$F$3:$W$3,)

as you need an EXACT match_type.

 

[KRE]

I know I can use an Xlookup to pull the value. I guess my question is why doesn't the sumif index match formula not work when it does for other columns.

=SUMIF('Billing Values'!$F$3:$F$130,$A5,INDEX('Billing Values'!$F$3:$W$130,,MATCH(C$4,'Billing Values'!$F$3:$W$3)))

This formula correctly pulls the value 68.06 when looking at the Interior Footings row and the Contract Quantity Totals column and finding it in the billing values tab.

However,

=SUMIF('Billing Values'!$F$3:$F$130,$A5,INDEX('Billing Values'!$F$3:$W$130,,MATCH(B$4,'Billing Values'!$F$3:$W$3)))

This formula incorrectly pulls the value 213.05 when looking at the Interior Footings row and the Price/Per column from the Analytics tab and finding it in the billing values tab. But in the Billing values tab that value is under the Labor column. What it should have pulled was the value 594.64.

 

[StephenCrump]

You need an EXACT match. To illustrate:

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	Billing	Contract	Weekly	Quantity	% Remain	Price	Concrete	Equipt	Misc	Fuel	Labor	Tax	Stone	Profit	Variance	Rebar	Inhouse	SubContract
2		68.06				594.64					213.05
3
4		Wrong	Right
5	Contract	68.06	68.06	You got lucky!
6	Price	213.05	594.64
7	Labor	68.06	213.05
8
Sheet1

Cell Formulas
Range	Formula
B5:B7	B5	=INDEX($A$2:$R$2,MATCH($A5,$A$1:$R$1))
C5:C7	C5	=INDEX($A$2:$R$2,MATCH($A5,$A$1:$R$1,))

 

[KRE]

Thank you! What I was missing was the comma after the match formula. And yes I did get lucky.