This should be easy, but I'm struggling

[bobsmith58d]

I want to make 'sheet2' with three colums:

'item#' 'Description' 'Price'

I'll have, say 50 items (integer), with their accompanying description (string) and prices (integer) on 'sheet 2.'
On sheet 1, I want to write a function where I can input any item#, and then the 'Description' and 'Price' that correlate to that item# will automatically show up in the adjacent colums. There will also be a colum for 'Quantity of item.' I'm not sure if I need to use an array or not (which I'm confused on how to use).
The purpose is for a customer who wants to buy, say 5 items (or however many they choose), to only input the item# and quantity of that item, and then it will automatically display those items, their description, their prices, and then finally it will add up the total price, based on the unit prices.

'Sheet1' would look like this:

'item#' 'Description' 'quantity' 'unit price' 'total price/item'


Total Price: $



I appreciate anyone who can help me out with this. I'm sure it's pretty easy - I'm just not very good with Excel. Thank you so much.

-Bob

[pinmaster]

Hi
How about something like this....

=IF(A1>0,VLOOKUP($A1,Sheet 2!$A$1:$E$50,2,0),"")...for the item description and..
=IF(A1>0,VLOOKUP($A1,Sheet 2!$A$1:$E$50,3,0),"")...for the item price
and for the total price per item...
=IF(C1>0,C1*D1,0)

you can copy those formulas down as needed.

Hope this helps!
JG