+ Reply to Thread
Results 1 to 6 of 6

Create a material price list with varying x and y properties

  1. #1
    Registered User
    Join Date
    05-18-2016
    Location
    South Australia
    MS-Off Ver
    MS 2013
    Posts
    2

    Create a material price list with varying x and y properties

    Hi my name is Adrian, and I am new to this forum and have an intermediate understanding of excel.
    However, I have no idea where to begin with my next question.

    I work for a company that sells flyscreens. Our manufacturer has specific costs that vary depending on the size(mm) of the flyscreens.
    We would like to save time instead of manually finding the information, by creating a spreadsheet that we can input the specific dimensions of the screens that correspond with the price.

    I have attached a file that hopefully will explain what I mean.
    The top information would be based on the below information.

    Looking forward to hearing any responses to this.
    Cheers.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2024
    Posts
    6,175

    Re: Create a material price list with varying x and y properties

    Try this formula in D3:
    =INDEX($B$14:$U$33,MATCH(C3,$A$14:$A$33,0),MATCH(B3,$B$13:$U$13,0))
    Copy down.

  3. #3
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Create a material price list with varying x and y properties

    Here's another one...

    Entered in D3:

    =VLOOKUP(C3,$A$13:$U$33,MATCH(B3,$A$13:$U$13,0),0)
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  4. #4
    Registered User
    Join Date
    05-18-2016
    Location
    South Australia
    MS-Off Ver
    MS 2013
    Posts
    2

    Re: Create a material price list with varying x and y properties

    Thanks guys,
    This works a dream.
    I can now take this and add other features to make it do all that we need.
    Much appreciated.

  5. #5
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Create a material price list with varying x and y properties

    You're welcome. Thanks for the feedback!

  6. #6
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2024
    Posts
    6,175

    Re: Create a material price list with varying x and y properties

    You're welcome!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 12-16-2015, 05:50 AM
  2. Replies: 3
    Last Post: 09-12-2015, 10:42 AM
  3. Replies: 4
    Last Post: 09-12-2015, 04:34 AM
  4. [SOLVED] create master list from varying worksheets
    By shaz0503 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-07-2014, 06:52 PM
  5. Excel 2007 : Lookup of material price based on date range
    By posttoamit in forum Excel General
    Replies: 1
    Last Post: 02-18-2011, 08:58 AM
  6. [SOLVED] How to create a formula 5 to 10% based on given list of price
    By working on variable in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-13-2006, 03:55 AM
  7. [SOLVED] making one material list from mulitple vendor material lists
    By In the beginning in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-07-2005, 11:08 PM

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