Index Small and If in Excel for multiple criteria

Hi All I have been trying to use the formula below and to alter it for multiple conditions

{=INDEX($C$1:$C$51,SMALL(IF($A$1:$A$51="Adeline",ROW($A$1:$A$51),""),3),1)}

I have a table on sheet1 called Data and a page for calculations. There is a matching ID on both sheets though in the table on sheet1 an ID could be on multiple rows. Also the CODE column could contain in this case TEST2 multiple times for same ID but with different Values. I am trying to in this case find the 3rd value for this combination.

So I trying to find out a value based on ID and a column called Code but I would like the 3rd value

So I've tried altering the IF part of the statement

{=INDEX(Data[Value],SMALL(IF((Data[ID] =[@ID])*(Data[CODE] = "Test2") ,ROW($A$1:$A$51),""),3),1)}

and

{=INDEX(Data[Value],SMALL(IF((AND(Data[ID]=[@ID], Data[CODE] = "Test2") ,ROW($A$1:$A$51),""),3),1)}

Both Come up with errors - any advice or am I looking at this completely in the wrong way.