hi
what is the best way to do this , if at all possible?


i have two excel

number 1
http://img687.imageshack.us/img687/3692/95357292.jpg

number 2

http://img693.imageshack.us/img693/7696/91043315.jpg

i want to pull the stock and price from excel book 2 into excel book 1


i need excel book one to look inside number 2 for the unique OEM code then pull the price and stock of that entry into excel number one...

then put the stock and price in the columm in the correct places..


hope thats not too confusing


any help would be great