autofilling out form from list

B

Brad

I hope I can explain this the way my mind sees it.

I have a form that is incredibly long for a program that
needs the information submitted in that format. The
problem is it could take me forever to fill it out. I have
the basic information the form needs. Here is an attempt
to explain the spreadsheet..
Columns
[ A ] [ B ] [ C ] [ D ]
[1]Item Text Text
[2]Item Text Price Text
[3]Item Text Text
[4]Item Text Text
[5]Item Text Text

I have a list on a seperate page that has the item# and
the price for say 1000 items, the "form" you see above is
just for one item(each form is repeated below the other
for the next item), the item number is listed 5x's and the
price is listed once. I need this form to be filled out
over 1000x's by referencing the list of items on a
seperate page in the same file. If this makes sense to you
please help! I don't want to spend countless hours filling
out forms for work when I could be doing homework for
school.
 
B

BrianB

How about a VLOOKUP() formual (see Excel help) that will look up an ite
number in a list and return the price
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top