Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Misc
Excel Formula
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Gary''s Student, post: 3201766"] You need to do two lookups: 1. a VLOOKUP() to get the List Price given the part number 2. a two-dimensional lookup to get the discount given the part number and classification Once you have both the list price and the discount, you can calculate the selling price. Two-dimensional lookups are described in: [URL]http://www.cpearson.com/excel/TablesAndLookups.aspx[/URL] checkout the first example. [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Misc
Excel Formula
Top
