CFSbookkeeper
New Member
- Joined
- Sep 16, 2011
- Messages
- 3
Hello, I saw an Excel instructor type up an invoice in Excel. He type one package part number and it filled in all the products and prices that made up that package. How do I do that?
Example:
I type in__________ These two columns fill
this column________ in (from another worksheet pg)
Package1________ FRS24________ 5.00
________________ABC36_______ 26.00
________________RL1S________ 19.00
________________GR9XL______ 100.00
This package is made up of 4 parts. After typing in "Package1" I want the other two columns to fill in for however many pieces make up that package (which varies), and the price. Then I want it to return to the next line, so that in the first column, so that I can enter the next package number.
Would this work with VLOOKUP, or do I need to do something else?
Example:
I type in__________ These two columns fill
this column________ in (from another worksheet pg)
Package1________ FRS24________ 5.00
________________ABC36_______ 26.00
________________RL1S________ 19.00
________________GR9XL______ 100.00
This package is made up of 4 parts. After typing in "Package1" I want the other two columns to fill in for however many pieces make up that package (which varies), and the price. Then I want it to return to the next line, so that in the first column, so that I can enter the next package number.
Would this work with VLOOKUP, or do I need to do something else?
Last edited:
