Assistance Required : Copy when conditions are met

[chrisnilu]

i need to copy values from a table when 2 other conditions are met.

Table 1 [TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]COUNTRY[/TD]
[TD]TYPE[/TD]
[TD]Details[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]AZ[/TD]
[TD]READ[/TD]
[TD]This is used for reading in AZ[/TD]
[/TR]
[TR]
[TD]AB[/TD]
[TD]UK[/TD]
[TD]Write[/TD]
[TD]This is used for writing in UK[/TD]
[/TR]
[TR]
[TD]CD[/TD]
[TD]US[/TD]
[TD]EDIT[/TD]
[TD]This is used for editing in US[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]AZ[/TD]
[TD]Write[/TD]
[TD]This is used for writing in AZ[/TD]
[/TR]
</tbody>[/TABLE]

Table 2

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]COUNTRY[/TD]
[TD]TYPE[/TD]
[TD]DETAIL[/TD]
[/TR]
[TR]
[TD]XY[/TD]
[TD]AX[/TD]
[TD]Edit[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]AZ[/TD]
[TD]READ[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CD[/TD]
[TD]US[/TD]
[TD]Write[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

In Table 2 Detail column i need to get the same details as Table 1 if ID, Country & ID are matched . What function or formula should i use ?

 

[mart37]

=if(sumproduct(($a$2:$a$5=f3)*($b$2:$b$5=g3)*($c$2:$c$5=h3)*rij($1:$4))>0,index($d$2:$d$5,sumproduct(($a$2:$a$5=f3)*($b$2:$b$5=g3)*($c$2:$c$5=h3)*row($1:$4))),"")

 

[chrisnilu]

Much appreciated, thanks