Finding a part number

P

PR Pillai

Hi,
I have an excel workbook with two work sheets, In the firs sheet I have
cells with header as Part No., description & price and in my seconwork sheet
I have designed as a invoice, so that when I type the part number it should
automatically display the description and quatity which I have enetered in
the first work sheet. Could any one be able to help me to solve this issue.
Thanks in advance
PR Pillai
 
G

Gordon

PR Pillai said:
Hi,
I have an excel workbook with two work sheets, In the firs sheet I have
cells with header as Part No., description & price and in my seconwork
sheet
I have designed as a invoice, so that when I type the part number it
should
automatically display the description and quatity which I have enetered in
the first work sheet. Could any one be able to help me to solve this
issue.
Thanks in advance
PR Pillai
Click to expand...


You need a "Lookup" formula in the Invoice. as this would be quite
complicated, I suggest initially you look in Excel help. and also have a
look here:
http://www.cpearson.com/excel/lookups.htm

BTW - this is nothing to do with templates....
 

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

Similar Threads

Section and Page numbering 0
Time & Billing Invoice 1
To Convert Amount Figures Into Text 1
is this possible in excel 2007 3
I'm sure its an easy answer.... 1
copy specific cells from sheets if the information is correct 3
Help with using vlookup and acting on the results 2
Creating a template that I can reproduce every month by keying ininformation from SAP 8

Top