Say I enter a formula in Collumn (B2) and Is there a formula that it could reads if collumn (A2) '2207' of that workbook then it looks for that paticular part number in the other workbook collumn (A2:A2000) and when it finds it and grabs whatever value next to it say in collumn (C)

I tried to use this formula but it doesnot work.

=INDEX([mx20105.xls]Sheet1!$A$2:$A$222,MATCH(A2,[mx20105.xls]Sheet1!$C$2:$C$222,0))