Need SecondSearch base on Header with 1st Search to match row

[nojoke1105]

Here is 2 worksheets, Source and Result

Source was directly cut the XML/JSON on dynamic tag order.
Expected result will be first MATCH Column A (the Key, 0), get the row#, example is 4.
need second search base on SOURCE!$4:$4 from above result, find the Header h3 in somehow Column
Maybe 2, 4, 6 or NOT exist.
Take the next field if found h3

The attachment is just 4 rows as sample case.

Thank you for your support.

p.s. As company privacy, I am NOT allow to use any online tool to convert the xml.

[JohnTopley]

Try

=SUMPRODUCT((Source!$C$1:$G$4),(Source!$A$1:$A$4=$A2)*(Source!$B$1:$F$4=B$1))

custom format as

0;-0;;@

[nick.williams]

A different approach...

=IFERROR(INDEX(INDEX(Source!$C$1:$G$4,MATCH($A2,Source!$A$1:$A$4,0),0),MATCH(B$1,INDEX(Source!$B$1:$F$4,MATCH($A2,Source!$A$1:$A$4,0),0),0)),"")

[nojoke1105]

Thank you, Nick Williams.
Of cos, the real case the taken next Column may be non-digit.
Sorry, I just misleading for giving only number to take.

This formula is wonderful, it can help to resolve any XML/JSON without using tools.

For example, use notepad replace:
＜h3＞hello＜/h3＞
＜h5＞785＜/h5＞
...
=>
＜h3＞hello＜/h3＞●＜h5＞785＜/h5＞● ...

for import delimited●, then easier cut to Source sheet style,
Everything will be alright.