VLookup

G

Guest

I'm try to set up a small invoicing system. I've got a
customer info sheet, a product list sheet, and I'm
putting together an Invoice to get info from those sheets.
All three are excel sheets.
Any ideas of how I can get started.
 
S

Sean

Each sheet that has the info on it ie (product list, and
customer info sheet) need to have the information you are
looking for to be sorted alpabetically in the very first
column A
For example

Product # Cost
123456 $13.00
123457 $12.00
123457 $25.00

Then the invoice sheet will search for the product number
in the product number sheet and then will display the
invoice. In help search for vlookup
But this will get you started.

Sean
 
Top