Adding a sum function to my Vlookup/Hlookup

[Quinn11]

I am trying to add a sum function to my lookup formula. =VLOOKUP($G11,$A$7:$D$12,HLOOKUP($H$5,$B$5:$D$6,2,FALSE),FALSE)

I am trying to Lookup the number in column G in the main table and return the result depending on when I change H5

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Quinn11]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

I'm on 365. Thanks for the heads up

 

[Fluff]

Thanks for that.
How about

=SUMIFS(XLOOKUP($H$5,$B$5:$D$5,$B$7:$D$12),$A$7:$A$12,G8)

 

[Peter_SSs]

.. or you can do them all with a single formula like this

23 08 18.xlsm
	A	B	C	D	E	F	G	H
5		Red	Yellow	Green				Red
6
7	601	10	11	20
8	602	20	12	20			601	10
9	603	30	13	20			602	20
10	605	40	14	20			603	30
11	605	50	15	20			605	150
12	605	60	16	20
SUM

Cell Formulas
Range	Formula
H8:H11	H8	=BYROW(G8:G11,LAMBDA(r,SUMIFS(INDEX(B7:D12,0,MATCH(H5,B5:D5,0)),A7:A12,r)))
Dynamic array formulas.