Compare columns in different Files

HI, Try

Formula:

=IF(AND(V:V='[HW inbound shipment info 21 Oct (2).xls]Inbound'!$W:$W,K:K='[HW inbound shipment info 21 Oct (2).xls]Inbound'!$X:$X),VLOOKUP('[HW inbound shipment info 21 Oct (2).xls]Inbound'!$U:$U,1,0),"No Match")