Compare columns in different Files

[Will03]

I have two excel files that I need help with a formula to return a value from one file to another... First in my Import File I filter Column H by N/A then Filter Column I by Opto (its a provider)... I need to compare the P/N in Column V on the import file with the Item in column W on the inbound file and do the same with the QTY in column K on the import file with the qty in column X of inbound file... Only if both columns match I need it to return the value from Column U of the inbound file to column H of the import file...

Can anyone help on this issue? I was attempting to use IF with Vlookup but have had no luck all morning here...

=IF(V:V='[HW inbound shipment info 21 Oct (2).xls]Inbound'!$W:$W,AND(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)))

This is what I used and just get a True or False but not the value of the actual U column???

[boopathiraja]

HI, Try

Please Login or Register  to view this content.

[Will03]

It is just giving me No Match for everything. There are a few of them that do match and it should return the value in the U column and its not, it still says No Match...