Assistance Required : Copy when conditions are met

[chrisnilu]

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

Table 1

ID	COUNTRY	TYPE	Details
AA	AZ	READ	This is used for reading in AZ
AB	UK	Write	This is used for writing in UK
CD	US	EDIT	This is used for editing in US
AA	AZ	Write	This is used for writing in AZ

<tbody>
</tbody>

Table 2

ID	COUNTRY	TYPE	DETAIL
XY	AX	Edit
AA	AZ	READ
CD	US	Write

<tbody>
</tbody>

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