View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CP CP is offline
external usenet poster
 
Posts: 64
Default Help please with a lookup problem

I am trying to use a form to lookup data from another sheet and struggling

Sheet1 contains three columns "qty, desc, price"
My form sheet "DATA Sheet" has the same three columns.

I wish to type in the description column on the form any part of a product
name and then the function to either pull in the correct one or provide a
list of matching types but it also needs to pull in the price as well.

Where do I begin??