lookup value

[aarky]

how to solve this puzzle

 

[Fluff]

Hi & welcome to MrExcel.
How about

ZFluff.xlsm
	D	E	F	G	H	I	J	K	L	M	N	O
4	Quarter	Month	Amount	Quarter	Month	Amount				Quarter	Month	Amount
5	qt1	jan	7890	qt2	apr	3890				qt2	apr	3890
6	qt1	fab	8970	qt2	may	8990
7	qt1	mar	5670	qt2	jun	7890
8	Quarter	Month	Amount	Quarter	Month	Amount
9	qt3	jul	2899	qt4	oct	9789
10	qt3	aug	8765	qt4	nov	6383
11	qt3	sep	3948	qt4	dec	8389
Main

Cell Formulas
Range	Formula
O5	O5	=SUMPRODUCT((D5:G11=M5)*(E5:H11=N5),F5:I11)

 

[VBE313]

Please insert the following function below in a Module. After you do this, go to cell O5 and type "=GetAmount(D4:I11,M5,N5)"

Option Explicit
Function GetAmount(Rng1 As Range, qtr As String, month As String) As Variant
Dim cl As Object
    For Each cl In Rng1
        If cl.Value = qtr And cl.Offset(0, 1).Value = month Then
            GetAmount = cl.Offset(0, 2).Value
            Exit For
        Else
            Debug.Print cl.Value
            GetAmount = 0
        End If
    Next cl
End Function