Formula help needed

[Alex D]

I am trying to find the best way to pull in a value in the cell to the right of "enterprise", that looks at the second image, and matches what is in the first and second column here, and returns the 144939 value

01/20-01/26

Enterprise

		Calls Offered
01/20-01/26	Summaries	289878
01/20-01/26	Enterprise	144939

 

[Cubist]

Try:

Book1
	A	B	C
1
2	1/20-1/26	Enterprise	144939
3
4			Calls Offered
5	1/20-1/26	Summaries	289878
6	1/20-1/26	Enterprise	144939
Sheet1

Cell Formulas
Range	Formula
C2	C2	=XLOOKUP(1,(A5:A6=A2)*(B5:B6=B2),C5:C6)