Results 1 to 4 of 4

Auto insert price depending on product (from dropdown list) and client type.

Threaded View

  1. #1
    Registered User
    Join Date
    05-20-2014
    Posts
    3

    Auto insert price depending on product (from dropdown list) and client type.

    Good day.

    I am new with excel and would really appreciate your help.

    I have to make a formula that looks up a price from 3 different price columns on sheet "Price list" (depending on type of client) and the product selected form a dropdown list in "ITEM" column on sheet "Cover". Each client has a different price depending on what type of client they are.

    Please see the workbook attached.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Client code for differentiated client price
    By a1b2c3d4e5f6g7h8i9 in forum Excel General
    Replies: 5
    Last Post: 02-27-2014, 12:14 PM
  2. Getting price to autofill after picking product from dropdown list
    By wesxxx in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-26-2013, 08:12 PM
  3. Replies: 9
    Last Post: 02-13-2012, 07:07 AM
  4. Lookup manufacturing details depending on product type
    By h0pp9z in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 12-19-2009, 12:59 AM
  5. Client list price update
    By tljeffrey21 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-09-2006, 07:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1