help with hlookup formula - tia

[JRAMZ88]

Hi everyone - I'm hoping someone can help me with the following formula request.

I'm providing a sample data set that I quickly put together that essentially mirrors what I'm doing at work.

Can someone please help me write a formula that looks at Period 4 and Item C and returns the 550?

It seems like a rather easy request, but I'm stumped after tinkering with it all day… would this be an hlookup?

Thank you again and I appreciate your time!

 

[Michael M]

MAybe

=SUMPRODUCT(--($B$2:$B$6="C"),$E$2:$E$6)

 

[JRAMZ88]

I apologize.... i noticed I cut off the columns and rows... here's a better snip image if it helps.

Again, thank you for the help!

 

[Michael M]

Same formula, just change the range references.

 

[DataXcelGPT]

Try:
INDEX($E$5:$J$9,MATCH($D7,$D$5:$D$9,0),MATCH(H$4,$E$4:$J$4,0))

 

[JRAMZ88]

Thank you both! the index formula seemed to work best for me in this scenario.. marked it as solved.

I appreciate the community for helping!