Trying to create a requisition form that returns values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a requisition form that will allow users to enter
quantities next to items in a database and return quantities and lookup
values on a requistion form if the item was selected.

Can someone point me in the right direction what type functions would do this?

Thanks,
 
Hello and thanks for taking the time to respond. The problem I'm having using
the VLOOKUP is I'm trying to avoid the need to type in a material code to
retrieve the corresponding data. What I'm hoping to do is enter a quantity
next to a material code on a seperate worksheet and if there is a value have
the data automatically appear on the requisition form.
 
Back
Top