Gary's Student - Thanks for that info. one thing I forgot to mention and not
sure if it is covered by your wonderful solution - perhaps you can tell me -
my product info won't always be in the same row. For example if I am
entering orders from our buying group into the order form - one person will
order a product and another person might order the same product, but it will
be 30 lines down. Will this option allow for the query to search vertically
in the column of the table for the matching #, and match the data in the
other 3 columns similarly? Thanks much and God Bless - its so nice to get
information so fast!

"Gary''s Student" wrote:

Use Excel.

Build a table using columns E thru H. So column E would contain the item #
and F and G and H the other three pieces of data.

To use the table, enter the desired item # in cell A1 and the following
formulas in B1 thru D1:

=VLOOKUP(A1,E1:H100,2)
=VLOOKUP(A1,E1:H100,3)
=VLOOKUP(A1,E1:H100,4)

These will find and display the data from the correct row

Adjust the 100 to suit your needs
--
Gary''s Student - gsnu200771


"goalonggirl" wrote:

Not sure if I have the correct group here, or even if I am using the proper
language to explain what I want to do.

I need to use Excel (or Access or Works) to create a linkable product order
form. This needs to be able to go to the database I create, search for the
item # I input and then return to the next 3 columns in the row I am in the
values that go along with that item # in the database. (ie: 170113 would be
the item # and the next 3 columns would say 12 oz. Cranberry Juice
Concentrate, OG 3.75