Vlookup from different workbook

[GoodyCC]

Hey, i have 2 identically laid out workbooks. one that has a list of all product codes in column B, Item Description in Column C, Branding image in column D and image location in Column E. In the second we have the same layout just blank data. I'm trying to add product codes in column B but the for Column C,D and E to Look up the data from the first Sheet and pull it through automatically as Text rather than a formula. However i cant seem to even get it to look it the data to start with.

Any help appreciated

 

[GoodyCC]

Question Solved

 

[smozgur]

Glad to hear you got the solution.

Do you mind posting about your solution? Then it is perfectly fine to mark your post as the solution to help future readers.