Following worked for anyone else that may need.
Formula broken down
=Index('The column you are looking to return',MATCH('The first cell to match'&'The second Cell to match','Where to find the first cell column data range'&'where to find the second cell column data range',0 for exact match))
=INDEX('Asset Data'!D:D,MATCH('Distribution Log'!$AP3&'Distribution Log'!$P3,'Asset Data'!$G:$G&'Asset Data'!$A:$A,0))