Excel Vlookup HELP!! Please

[redplatinum2]

I have two excel files: Excel File A and Excel File B.

I want to look up and find a date on 'Excel File A' considering two columns.. Part number and Item Number (Which contains numbers and letters)

Then If the Part number and Item number matches I want to export the date associated with the two variables into a column in Excel File B.

(Basically im tryna match part & item numbers from file B with File A and export the date (in column C) from File A to B)

My english sucks, I hope you got the objective! Any help would be great

Thank you!
-Kevin​

 

[aaronbens]

You can either add a column and concatenate the Part Num and Item Num for each row or you can do and Index Match in the format as follows:

{=INDEX([File A]Sheet1!$C$8:$C$150,MATCH(A4&B4,[File A]Sheet1!$A$2:$A$150&[File A]Sheet1!$B$2:$B$150,0))}

Return with Ctrl+Shift+Enter