VLOOKUP Enter an item number get product title, price etc. from multiple spreadsheets,how?

Hi everybody

I need some help.

I have a list of items and I want a function which fills in price and such after I enter an item number. I think that vlookup should do the trick, but I don't know how to use it properly.
Any advice?
Thanks in advance.