VLookup Function

[perlox]

I'm using Excel 2007 and I have an assignment I'm stuck on and was hoping I could get some help.
I need to write a simple VLookUp Funct but for some reason its not working.
I have two sheets, one is called Invoice which contains a sample invoice for a customer with item numbers, their description, quantity, unit price and extended (total) price. The second sheet is a product table that contains each items number and the information that would be filled in the invoice (ie. description and unit price).
So, what I need to do is write a LookUp funct that displays the description and unit price when the Item Number is typed in.
ex. If I type in Item Number 21, I need it to display "Product Name" and "Unit Price."
I tried "=VLOOKUP(A5,Product!A3:C9,(2,3),TRUE)" and it only displayed the Product Description name. How do I get it to show the Product Description Name and then Unit Price?

[Rynofasho]

Can you not just use two different cells? One for the description and one for the price? If the result has to be in one cell then I would just use two functions somewhere and concatenate them. Im not sure if it is possible to lookup two columns with the vlookup function. . .

[Thom23]

You can use an array formula to accomplish what you are trying to do. Highlight the cells you want the formula to cover, use { instead of ( for the opening and closing paren's/brackets, and use ctl+alt+enter in combination to activate the array.

"=VLOOKUP(A5,Product!A3:C9,{2,3},false)"

I always use false so that it doesn't return something I'm not anticipating.