View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
 
Posts: 1,089
Default Is Excel capable of doing this function?

Use VLOOKUP

Regards

Trevor


"JacisChildCare" wrote in message
...
I have created an invoice to use for my scrapbook business. I don't know if
excel can do the following thing or not. If it can, how do I set it up to
function?

I have a place for an item number. Is there a way to enter the item number
(z1561) and have the discription (stamp pad set) and the price (26.95)
automatically come up. I know if it can, I will have to create the entire
inventory list for all products.

Thanks for any help.