Results 1 to 2 of 2

Client Price Listing

Threaded View

  1. #1
    Registered User
    Join Date
    08-19-2011
    Location
    st cath, ont
    MS-Off Ver
    Excel 2003
    Posts
    1

    Client Price Listing

    Hi, Im a first timer on forum so will try to be clear.

    I have a sheet with products (columnA) and prices of 4 levels (column B, C, D, E). Each combination of cell beeing a price.
    Then I have colum F, G H, to ... beeing each a client name. In each of these column I have already a letter "a" or "b" corresponding to the heading of column B,C,D,E (basically telling client xyz is on level a,b,c or d)
    note, one client always have different levels of pricing depending on which product line

    Is there a formula that can automatically pull out each product price for each client according to their level of pricing by product?

    see here below an example but it looks like the forum window is compressing everything. Also a example file attachement (the yellow partbeeing what the results should look like... )

    (A1 cell) list a list b list c list d client a client b client c client a client b client c
    product a $1.00 $10.00 $21.00 $31.00 a b c $1.00 $10.00 $21.00
    product b $2.00 $11.00 $22.00 $32.00 a b c $2.00 $11.00 $22.00
    product c $3.00 $12.00 $23.00 $33.00 a b d $3.00 $12.00 $33.00
    product d $4.00 $13.00 $24.00 $34.00 a b d $4.00 $13.00 $34.00

    THANKS A BILLION FOR ANY SUGGESTIONS
    Seb
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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