98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Templates
Templates
Resolved · Low Priority · Version 2003
Thu 28 Aug 2008, 16:36Delegate Peter said...
Peter has attended:
Excel Intermediate course
Templates
On a template such as an invoice for example, how would I get my unit price column to automatically update in accordance with a separate itemised price list when a item number or name is inserted in the preceeding column?
Thu 11 Sep 2008, 14:36Trainer Alan said...
RE: Templates
Hi Peter
You need to set up a VLOOKUP function on the template which looks up the value in the preceding column down the left column of the price list and returns the relevant price shown in the price list.
If you don't know the VLOOKUP function, use the insert function button for help and guidance.
Alan Burbridge
Best STL
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Outlining - ungrouping rows or columnsHighlight want you want to ungroup and press ALT + SHIFT + right cursor arrow |
