Lookup value in column based on criteria

[Juniad]

I have attached the sample file where am trying to look up expiry date based on emp code and card type. I have mentioned the manual result for better understanding.

 

[Nebu]

Hi:

Formula highlighted in yellow.

Thanks

 

[Juniad]

Great! Thank you.

 

[amit_gupta123]

Attached

 

[amit_gupta123]

Formula used
=TRANSPOSE(FILTER(D:D,G3=A:A))

Applicable for office 365