Trying to create a requisition form that returns values

[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,

 

[Gord Dibben]

VLOOKUP formulas will pull the data to appropriate cells.

See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html

Note the section on using DV lists from another worksheet by naming the list.


Gord Dibben MS Excel MVP

 

[Guest]

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.