Trying to create a requisition form that returns values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tim4104 - 29 Oct 2007 20:25 GMT

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,

Signature

Tim in Kennesaw

Reply to this Message

Gord Dibben - 29 Oct 2007 21:11 GMT

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

>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
[quoted text clipped - 3 lines]
>
>Thanks,

Reply to this Message

Tim4104 - 30 Oct 2007 11:51 GMT

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.

Signature

Tim in Kennesaw

> VLOOKUP formulas will pull the data to appropriate cells.
>
[quoted text clipped - 16 lines]
> >
> >Thanks,

Reply to this Message